`DROP INDEX' Syntax
-------------------
DROP INDEX index_name ON tbl_name
`DROP INDEX' drops the index named `index_name' from the table
`tbl_name'. `DROP INDEX' doesn't do anything in MySQL prior to Version
3.22. In Version 3.22 or later, `DROP INDEX' is mapped to an `ALTER
TABLE' statement to drop the index. Note:`ALTER TABLE'.