Sql Create Table with Primary key, Foreign key and AutoIncrement

Create Table with Primary Key

Creating Department Table with Primary Key

Creating DepartmenId Primary Key And AutoIncrement

Identity is used to make a column Auto Increment. First Argument is Identity Seed, second argument is Identity Increment value.

Create Personel Table with Primary Key, Auto Increment And Foreign Key _1

Create Personel Table with Primary Key, Auto Increment And Foreign Key _2

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: