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

2 votes186 views1 answer
Date_format for time sql
SQL
1 vote143 views1 answer
Enable mysql slow query log
SQL
0 vote195 views1 answer
Get date ISO in psql
SQL
0 vote181 views1 answer
Sql find leading space
SQL
0 vote320 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
2 votes186 views1 answer
Mysql sysdate - 1 day
SQL
0 vote198 views1 answer
Disable database droping sql
SQL
0 vote190 views1 answer
Exit psql
SQL
1 vote182 views1 answer
Mysql select utc time in eastern time
SQL
0 vote187 views1 answer
Sql select column names starting with
SQL