How to delete Primary key in MySQL

In this post we will see how we can delete or remove primary key in MySQL table.

Alter command is used to remove the primary key from MySQL table.

Syntax

Alter Table table_name drop Primary key;

Example

alter table address drop primary key;

In the above example, Primary key will be deleted from the address table.

Scroll to Top