Add / REMOVE Primary Key to existing table

CREATE TABLE WITHOUT PRIMARY KEY

CREATE TABLE JSSTUDTABLE (SNO NUMERIC(10) NOT NULL)ADD PRIMARY KEY EXISTING TABLE

ALTER TABLE JSSTUDTABLE ADD PRIMARY KEY (SNO);

REMOVE PRIMARY KEY EXISTING TABLE

ALTER TABLE JSSTUDTABLE DROP constraint PK__JSSTUDTA__CA1EE06C63D8CE75

0 Comments

Featured Post

Microsoft Azure: Configure Azure App Service Logging

Azure App service logging are the output of runtime trace statement in the different app code. logging feature will help you might only want...

Popular Posts

Welcome to MSDEVBUILD.COM