MySQL Drop Index

We may have assigned some indexes to a table, and sometimes there is a need to remove those latched indexes from the table. DROP INDEX is explicitly used for that.

Syntax

ALTER TABLE table_name
DROP INDEX index_name;

Example

• Now we have a table called "rec" and want to remove the unique index assigned to it.
• Let us use this query to do this.

Here is the index of the rec table.

ALTER TABLE rec
DROP INDEX unique_email;

• The unique index assigned to the email has been removed. Let us check it out.

SHOW INDEXES FROM rec;  

• We can see here that the mentioned index has been removed.