How to Create Table in SQL SERVER?

How to Create a Table?


There are two ways to create Table

(i) With SQL Command

(ii)Without SQL Command

So, let's go with First way

(i) Create Table using SQL Command:-

Syntax:- 

Create Table table_name(Column_name1 datatype,column_name2 datatype,....)

Example:-

Create table Employee(Employee_Id Int,Employee_Name varchar(100), Employee_Department varchar(200) )

(ii) Without SQL Command:-

Step 1:-Right click on the table. Select New then select Table.

Step 2:- Enter Column name and datatype

Step 3:- Then Save the table.

Step 4:- Click OK.