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 vote203 views1 answer
Postgresql heritage
SQL
7 votes211 views3 answers
Sql server reset auto increment
SQL
0 vote201 views1 answer
Pl/ sql change currency
SQL
0 vote207 views1 answer
Implicit inner join table alias with id values
SQL
4 votes219 views2 answers
Float postgres
SQL
0 vote228 views1 answer
Mysql timediff
SQL
0 vote199 views2 answers
Select columns from 2 tables with foreign key
SQL
34 votes267 views6 answers
Sql change data type
SQL
6 votes201 views1 answer
Postgresql add enum value
SQL
0 vote213 views1 answer
Shell script to log mysql cpu usage
SQL