ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)
--I created this update Now i want to delete this Primary Key Using Query SQL Server
ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)
--I created this update Now i want to delete this Primary Key Using Query SQL Server
use following to find out the primary key constraint name
exec sp_help Persons
drop the Primary Key constraint
alter table Persons drop constraint the PK_constraint_name