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