Google News
logo
MySQL - Interview Questions
How to drop the primary key in MySQL?
MySQL primary key is a single or combination of the field used to identify each record in a table uniquely. A primary key column cannot be null or empty. We can remove or delete a primary key from the table using the ALTER TABLE statement. The following syntax is used to drop the primary key :
 
ALTER TABLE table_name  DROP PRIMARY KEY;
Advertisement