SQL Server 2016: Create a Table
Create a new database table using the SQL Server Management Studio GUI.
In SQL Server, you can create a new database table either via the SQL Server Management Studio graphical user interface (GUI), or by running an SQL script.
Create a Table using the GUI
Here, we will create a database table using the GUI method.
Create a New Table
Add the columns that need to go into the table. Also specify the data type for each column, as well as any other properties that you need to.
For this tutorial, we'll add the following columns/data types:
Set an Identity Column
Set a Primary Key
Save the Table
Check that the Table was Created
When you first open the Tables node in the Object Browser, your initial response might be that the table wasn't even created. Your table is nowhere to be seen!
But relax... all you need to do is refresh the Object Browser.
Refresh the Tables Node
Your New Table