How to remove primary key in SQL?

Question

Can anyone tell me how to remove the primary key in SQL?

Answer 1

We can use DROP CONSTRAINT command in SQL server to remove the primary key from the table:

ALTER TABLE TableName

DROP CONSTRAINT ColumnName;

In MySQL, here is the syntax to remove the primary key from the table:

ALTER TABLE TableName

DROP PRIMARY KEY;

If you want to become a SQL expert, then take up this SQL training course by Intellipaat that provides instructor-led training and hands-on experience.