How do you create a table in Microsoft SQL Server database?

There are two basic options:

Using SSMS designer

• Connect to the SQL Server instance
• Go to the Database and expand its node in Object Explorer
• Right click the node Tables and select New-Table
• Define the columns and their data types
• Click Save

Writing and executing SQL script using SSMS query window

• Connect to the SQL Server instance
• Go to the Database and expand its node in Object Explorer
• Click the New Query to open the query window
• Enter the SQL script for creating the table and execute it

CREATE TABLE People (
	Id int,
	FirstName nvarchar(20),
	LastName nvarchar(20)
)