Time for action – Creating the Categories table
In this second exercise, we want to create the first table in our OrderingSystem database.
- Open SSMS and in the Object Browser expand the Databases folder. Locate the OrderingSystem database we created in the previous exercise and expand it.
- Right-click on the Tables folder and select New Table…, as shown in the following screenshot:
- SSMS will open a new tab where we can now define the details of the new 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