How to view indexes for all tables in MySQL?

2 years ago
Sophia Anderson
1 minute

You can use the following SQL statement to view all indexes of tables in MySQL:

SELECT 
    TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM 
    INFORMATION_SCHEMA.STATISTICS
WHERE 
    TABLE_SCHEMA = 'your_database_name'
ORDER BY 
    TABLE_NAME, INDEX_NAME, SEQ_IN_INDEX;

Please replace “your_database_name” with the name of the database you want to query.

This query will return the results in three columns: TABLE_NAME represents the table name, INDEX_NAME represents the index name, COLUMN_NAME represents the column name the index is on. The results will be sorted in the order of TABLE_NAME, INDEX_NAME, and SEQ_IN_INDEX.

Please note that this is just one way to check indexes. There are also other ways to view indexes in MySQL, such as using the SHOW INDEX statement.

bannerAds