drop a primary key

[davey23uk]

nice to see you did some research first!!!

once of

ALTER TABLE xxx DROP PRIMARY KEY
ALTER TABLE xxx DROP CONSTRAINT pk_xxx;
ALTER TABLE xxx DROP CONSTRAINT pk_xxx
CASCADE CONSTRAINTS;