- Add Two Primary Keys While Crating Table
|
1 2 3 4 5 6 |
Create table TableName( p1 int not null, p2 int not null, c3 varchar(20), primary key(p1,p2) ) |
|
1 2 3 4 5 6 |
Create table TableName( p1 int not null, p2 int not null, c3 varchar(20), constraint constraintName primary key(p1,p2) ) |
- Add Two Primary Keys To An Existing Table
|
1 2 |
Alter table TableName Add primary key(column1,column2) |
|
1 2 |
Alter table TableName Add constraint constraintName primary key(column1,column2) |
