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