DROP INDEX
DROP INDEX index_name ON tbl_name
index_name
tbl_name
DROP INDEX drops the index named index_name from the table tbl_name. This statement is mapped to an ALTER TABLE statement to drop the index. See Section 13.1.2, “ALTER TABLE Syntax”.
ALTER TABLE
