Let's create some tables for the users, questions, and answers in our new database in SSMS:
- Copy the contents of the SQL Script at https://github.com/PacktPublishing/ASP.NET-Core-3-and-React-17/blob/master/Chapter07/backend/SQLScripts/01-Tables.sql
- In SSMS, with the QandA database highlighted, click New Query on the toolbar to create a new SQL query and paste in the contents from the copied script.
- Click the Execute option on the toolbar or press F5 to execute the query.
- If we look under Tables in Object Explorer, we should see that several tables have been created:
The following have been created: