Delete index

To drop the index, use the "alter table ~ drop index" command.

alter table table name drop index index name;

This is a sample to delete the index of book_author_id of book table.

alter table book drop index book_author_id;

Please refer to the following articles to check if the index has been deleted.

If you want to create an index, please refer to the following articles.

Associated Information