DROP INDEX drops the index named
index_name from the table
tbl_name. In MySQL 3.22 or later,
DROP INDEX is mapped to an
ALTER TABLE statement to drop the
index. See Section 12.1.2, “
ALTER TABLE Syntax”.
DROP INDEX does not do anything
prior to MySQL 3.22.