How to see indexes for a database or table in MySQL?

To see the index for a specific table use SHOW INDEX:

SHOW INDEX FROM yourtable;

To see indexes for all tables within a specific schema you can use the STATISTICS table from INFORMATION_SCHEMA:

SELECT DISTINCT    TABLE_NAME,    INDEX_NAMEFROM INFORMATION_SCHEMA.STATISTICSWHERE TABLE_SCHEMA = 'your_schema';

Removing the where clause will show you all indexes in all schemas.

mysql indexing database-schema

If you want to see all indexes across all databases all at once:

use information_schema;SELECT * FROM statistics;

mysql indexing database-schema

SHOW INDEX FROM mytable FROM mydb;SHOW INDEX FROM mydb.mytable;

CodeHunter