Show indexes mysql

SHOW INDEX FROM yourtable;

Source: stackoverflow.com

How to see which columns are indexxed mysql

SHOW INDEXES FROM table_name;

Check all indexes on table

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

Similar codes

1 vote214 views2 answers
Maximum number of tables in mysql
SQL
25 votes209 views5 answers
Uninstall mysql ubuntu
SQL
0 vote191 views1 answer
Oracle enable chain
SQL
1 vote195 views1 answer
Sql trigger before delete
SQL
0 vote209 views1 answer
Sql last 3 rows
SQL
0 vote200 views1 answer
Sql select first and last record of each group
SQL
1 vote204 views2 answers
Changes not showing on website server odoo
SQL
10 votes214 views4 answers
How to alter table name in mysql
SQL
1 vote184 views1 answer
Stored procedure return value
SQL
0 vote201 views1 answer
Get create sql of hibernqte entity
SQL