Build Your Own Database-Driven Website Using PHP MySQL [Electronic resources]

DROP INDEX

DROP INDEX index_name ON tbl_name

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