EN
MySQL - remove index from existing table
0 points
In this article, we would like to show you how to remove an index from the existing table in MySQL.
Quick solution:
xxxxxxxxxx1
ALTER TABLE `table_name`2
DROP INDEX `index_name`;or
xxxxxxxxxx1
DROP INDEX `index_name` ON `table_name`;In this example, we will remove the salary_index created in the previous article.
Query:
xxxxxxxxxx1
ALTER TABLE `users`2
DROP INDEX `salary_index`;or
xxxxxxxxxx1
DROP INDEX `salary_index` ON `users`;