DROP INDEX

DROP INDEX removes the named index from the specified table.

DROP INDEX index_name FROM table_name