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.