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

0 vote182 views1 answer
View psql output in horizontal scrolling
SQL
0 vote182 views1 answer
Oracle execute immediate quotes
SQL
8 votes206 views2 answers
Sqlsrv default port
SQL
0 vote174 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote170 views1 answer
Mysql join same table multiple times group by
SQL
0 vote166 views4 answers
Database stuck at restoring state
SQL
0 vote164 views1 answer
Mysql case when on date
SQL
1 vote167 views1 answer
Md5 encryption for existing records
SQL
0 vote178 views3 answers
Magento 2 order delete from db
SQL
0 vote180 views1 answer
Mysql remove bad character from all fields
SQL