DROP INDEX index_name ON tbl_name
DROP INDEX
drops the index named index_name
from the table
tbl_name
. DROP INDEX
doesn't do anything in MySQL
prior to version 3.22. In 3.22 or later, DROP INDEX
is mapped to an
ALTER TABLE
statement to drop the index.
ALTER TABLE
.