DROP INDEXindex_name
ONtbl_name
DROP INDEX
drops the index named
index_name
from the table
tbl_name
. In MySQL 3.22 or later,
DROP INDEX
is mapped to an
ALTER TABLE
statement to drop the
index. See Section 12.1.2, “ALTER TABLE
Syntax”.
DROP INDEX
does not do anything
prior to MySQL 3.22.
User Comments
Add your own comment.