DROP INDEX index_name ON tbl_name
DROP INDEX has the exact same effect as ALTER TABLE DROP INDEX, described in "ALTER TABLE".