Tuesday, 15 September 2015

How to create a table in SQL server with Management studio ?

Here are the few steps to create a new table in SQL server.

Step 1 :

Right click the tables folder and click the new table option.



 Step 2 : 

Enter the Column Name ,datatype and Allow Nulls columns.



If the allow Nulls column is checked then it will allow Null value,else it will not allow null value.

Step 3 : 

In Column properties (Highlighted in Red colour) ,we can change the identity Specification to specify the start value and seed value.Initially the identity specification will be NO.



Step 4 :

Now I changed the identity specification value as YES.Identity increment is changed as 1 and identity seed is changed as 1.



Now the EmployeeID column starting value will be 1 and increment value will be 1.

Step 5 :

Now we need to save the table using File ---> Save (or) Ctrl+S command.Now the Choose name popup will appear.Once the table name is entered click OK to save the table.



Step 6 :

Now we can see the new table "Employee"created in the tables folder.



Step 7 :

Expand the table name and You can see the columns which we created in step 2.








No comments:

Post a Comment