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 vote134 views2 answers
Mysql update two tables at once
SQL
5 votes127 views1 answer
Mysql select greater than yesterday
SQL
0 vote156 views1 answer
Oracle running queries
SQL
1 vote135 views1 answer
Clear screen command in psql
SQL
0 vote133 views1 answer
How to avoid duplicate records in sqlite
SQL
2 votes130 views1 answer
Mysql virtual column
SQL
3 votes158 views1 answer
What is having
SQL
0 vote133 views1 answer
Oracle archivelog usage
SQL
0 vote162 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote130 views1 answer
What alter does in db
SQL