how I can change the PK from one column to another

Rajesh Sharma

Could you explain to me how I can change the PK from one column to another, without deleting the column? I made a mistake in the column when assigning the PK and I have to change it

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago

alter table yourtable drop constraint yourtable_pkeycolumnName
ALTER TABLE yourtable 
  ADD PRIMARY KEY (NewPrimaryKeyColumn);

Rajanikant Hawaldar3y ago
PK puts a contraint. You can drop the constraint and create the new one.