MySQL Drop index

MySQL Drop index

Drop index from MySQL table using alter table syntax.

MySQL Drop index syntax

ALTER TABLE table_name DROP INDEX index_name;

Drop index example

ALTER TABLE `books` 
DROP INDEX idx_product_id;

Output

table `books` altered.