Create Table with Primary Key
Creating Department Table with Primary Key
1 2 3 |
Create table Department( DepartmentId Int Primary Key, DName varchar(50)) |
Creating DepartmenId Primary Key And AutoIncrement
1 2 3 |
Create table Department( DepartmentId Int Primary Key Identity(1,1), DName varchar(50)) |
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
1 2 3 4 5 |
Create table Personel( PersonelId Int Primary Key Identity(1,1), Name varchar(50), Surname varchar(50), DepartmentId int references Department(DepartmentId)) |
Create Personel Table with Primary Key, Auto Increment And Foreign Key _2
1 2 3 4 5 6 |
Create table Personel( PersonelId Int Primary Key Identity(1,1), Name varchar(50), Surname varchar(50), DepartmentId int, constraint fk_Per_Dep foreign key(DepartmentId) references Department(DepartmentId)) |
YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE