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