delete primary key sql server

https://stackoverflow.com/questions/737152/how-to-disable-primary-key-constraint-programmatically

ALTER TABLE mytable DROP CONSTRAINT PK_Name

To reenable it:

ALTER TABLE mytable ADD CONSTRAINT PK_Name PRIMARY KEY /* CLUSTERED */ (pk_column)

Tweet