Hi I need a help for removing a PK from a table which has multiple primary keys. I think the code at the below just removes the constraint. I don't want remove the constraint, as I said there multiple primary keys and I want to remove just one of them to make it foreign key. Could you help me please? Thanks
ALTER TABLE tablename
drop CONSTRAINT pk_columnname;