display index in sql code example

Example 1: display index in sql

SHOW INDEX FROM yourtable;

Example 2: display index in sql

SELECT DISTINCT
    TABLE_NAME,
    INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';