MariaDB Tutorial

Check the index

Use the "show create table" command to see the index.

# Check index
show create table book;

You can see the index definition in the row named "KEY".

KEY `book_author_id` (`author_id`)

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

• Create an index

If you want to delete the index, please refer to the following article.

• Delete index