April 6, 2015

Delete primary key from a table in SQL Server

CREATE TABLE SampleTable
(
C1 INT NOT NULL,
C2 VARCHAR(100)
CONSTRAINT PK_SampleTable_C1 PRIMARY KEY CLUSTERED (C1 ASC)
)
GO

We can use ALTER command to drop primary key in SQL Server.

ALTER TABLE SampleTable
DROP CONSTRAINT PK_SampleTable_C1
GO

No comments:

Post a Comment