MySQL Show Index

Last Updated: 25 June, 2023

To show the indexes of a table in MySQL, we can use the SHOW INDEX statement.

Here's the syntax:

 SHOW INDEX FROM table_name;

Replace table_name with the name of the table for which we want to see the indexes.

Here's an example:

 SHOW INDEX FROM customers;

This command will display information about the indexes defined on the customers table, including the index name, column names, index type, and cardinality.

Note that we need appropriate privileges to execute this command, such as the SELECT privilege on the table or the SHOW VIEW privilege.