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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License