show index mysql code example

Example 1: mysql show indexes on table

SHOW INDEXES FROM table_name;

Example 2: show indexes mysql

SHOW INDEX FROM yourtable;

Example 3: check all indexes on table

SELECT
    tablename,
    indexname,
    indexdef
FROM
    pg_indexes
WHERE
    schemaname = 'yourschema' and tablename='yourtable'
ORDER BY
    tablename,
    indexname;
(POSTRGRESQL)