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.
Drop index from MySQL table using alter table syntax.
ALTER TABLE table_name DROP INDEX index_name;
ALTER TABLE `books` DROP INDEX idx_product_id;
table `books` altered.