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

Understanding about Azure Region, Geographies, Availability Zones and Region Pairs

Introduction Microsoft Azure services are available in 53 regions around the world, with plans announced for 7 additional regions and 140+ a...

Subscribe to the FREE Weekly Newsletter to receive all the latest Microsoft Azure, AI, Xamarin

Popular Posts