In this article, we would like to show you how to remove an index from the existing table in MySQL.
ALTER TABLE `table_name` DROP INDEX `index_name`;
DROP INDEX `index_name` ON `table_name`;
In this example, we will remove the
salary_index created in the previous article.
ALTER TABLE `users` DROP INDEX `salary_index`;
DROP INDEX `salary_index` ON `users`;