How can we get the list of all the indexes on a table?

We can use following command to get the list of all the indexes on a table in MySQL:

SHOW INDEX FROM table_name;

At maximum we can use 16 columns in a multi-column index of table.

Leave a Reply

Your email address will not be published. Required fields are marked *