Create table in SQL server

  Hi guys , in this blog post we will see how to create table in SQL server. This post is for SQL server beginners.

We can create table in SQL server using UI or by using SQL query.

Create table using UI:-

Please follow below steps:-

1)Go to start menu and search for SSMS(SQL server management studio) and click on SSMS.

2)Login into SQL server. Select server name then enter username and password. Click on connect button.

3) Go to object explorer. Expand databases then expand database. Select tables and right click on it. Select new table option.

4) Enter table column names and data type of column. Specify identity specification column. In my case EmployeeId is auto increment column.

5) Set table primary key.

6) Save table with proper name.

Create table using SQL query:-

SQL Script:-

CREATE TABLE [dbo].[tblEmployee](

[EmployeeId] [int] IDENTITY(1,1) NOT NULL,

[EmployeeFirstName] [varchar](100) NOT NULL,

[EmployeeLastName] [varchar](100) NOT NULL,

[CreatedDate] [datetime] NOT NULL,

[ModifiedDate] [datetime] NOT NULL

) ON [PRIMARY]

GO