The Dev Shelf
CREATE TABLE SampleTable(C1 INT NOT NULL,C2 VARCHAR(100)CONSTRAINT PK_SampleTable_C1 PRIMARY KEY CLUSTERED (C1 ASC))GOWe can use ALTER command to drop primary key in SQL Server.ALTER TABLE SampleTableDROP CONSTRAINT PK_SampleTable_C1GO
No comments:
Post a Comment