Wednesday, November 12, 2014

Creating A Sample Table In Sql server



1.Right click on the tables and new table

2.Creating a sample database with the 3 column name,email id,password
Make a  first column as a unique so here we have make it as int and autoincrement
Expand the identity specification and make a no to yes in the (Is Identity)
This will set the column the start from 1 and increment by 1 so it will always create a new value automatically

3.Now comes to next column
Name,email,password there is various data types like so select the appropriate type as per your need 

4. then click on the save it will ask for a popup says table name and write the table name over there and click on save

No comments:

Post a Comment