Syntax:
DROP INDEX index_name ON tbl_name

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 [HELP ALTER TABLE]. DROP INDEX does not do
anything prior to MySQL 3.22.
