How to delete an index in MySQL

Deleting an index in MySQL is quite simple, one query is enough.

Example:

ALTER TABLE `table_name` DROP INDEX `index_name`;

where:

table_name - table name
index_name - the name of the index to be removed

Comments

No comments yet, you can leave yours: