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 vote210 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
1 vote221 views1 answer
Mysql is odd
SQL
2 votes229 views1 answer
Orcale index size
SQL
10 votes232 views2 answers
SQL rounding numbers
SQL
0 vote229 views1 answer
To Create directory
SQL
3 votes246 views5 answers
Sql select
SQL
4 votes171 views1 answer
And or sql order of operations
SQL
0 vote215 views1 answer
Mysql config slave
SQL
-1 vote226 views1 answer
Concat two columns in sql server
SQL
1 vote229 views1 answer
Error code 1292 mysql workbench
SQL