How to delete Primary Key not A PRIMARY KEY Constraint using Query

ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)

--I created this update Now i want to delete this Primary Key Using Query SQL Server

  1. use following to find out the primary key constraint name

    exec sp_help Persons

  2. drop the Primary Key constraint

    alter table Persons drop constraint the PK_constraint_name

2 Likes