MySQL 8 Administrator???s Guide

Drop index command

The following command drops the index from the table. We can also map this statement with ALTER TABLE to drop the index from the table:

DROP INDEX index_name ON tbl_name [algorithm_option | lock_option]...algorithm_option:    ALGORITHM [=] {DEFAULT|INPLACE|COPY}lock_option:    LOCK [=] {DEFAULT|NONE|SHARED|EXCLUSIVE}

In this command, only two options are available: the algorithm and the lock. Both of these options are useful in the case of concurrent access of index and work, similar to the CREATE INDEX command. For example, to drop the index of an employee table, execute the following command:

DROP INDEX name_index ON employee;