Add / Drop Primary Key in SQL Server
Add
SQL command for adding primary key :
ALTER TABLE [TableName]
ADD CONSTRAINT pk_TableName PRIMARY KEY (EmployeeId)
|
Such as :
ALTER TABLE employee
ADD CONSTRAINT pk_employee PRIMARY KEY (EmployeeId)
Drop
SQL command for droping primary key :
ALTER TABLE [TableName]
DROP CONSTRAINT pk_TableName
|
Such as :
ALTER TABLE employee
DROP CONSTRAINT pk_employee
|
