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.
page revision: 0, last edited: 29 Dec 2008 20:28