MySQL - DROP INDEX

DROP INDEX index_name ON table_name;
DROP INDEX `PRIMARY` ON table_name;

To drop a PRIMARY KEY with DROP INDEX, refer to the index name (PRIMARY), but use a quoted identifier because this name is a reserved word.

Unlike ALTER TABLE, the DROP INDEX statement can only drop a single index per statement.