SQLTeam.com | Weblogs | Forums

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

sql2008r2

#1

ALTER TABLE Persons
ADD PRIMARY KEY (P_Id)

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


#2
  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