Let's get back to our Ordering system. If you remember, we will need a table to store the orders and one for the order items. Let's build those now!
Open up SSMS again and log in to your local database server—(local)\SQLExpress.
Click on the + next to the Ordering database so we can see the objects in our database.
Right-click on the Tables folder, and click on New Table to bring up the new table dialog tab. This is where we will define our first table.
The new table editor tab will look similar to the table in the following screenshot. In the Column Name box, enter Id, either type or select int in the Data Type field, and uncheck the Allow Nulls checkbox.
Next we need to set our "Primary Key" on this field. Right-click on the black arrow to the left of the Id column, and select Set Primary Key from the drop-down menu.