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 vote336 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote331 views1 answer
Primary key multiple colums
SQL
8 votes329 views1 answer
Oracle search code in packages
SQL
4 votes343 views2 answers
Oracle drop job
SQL
0 vote296 views1 answer
Ms Sql set us timezone
SQL
0 vote306 views1 answer
Mysql set boolean default value
SQL
3 votes407 views1 answer
Oracle nextval insert
SQL
0 vote314 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote309 views1 answer
Sqlite higher or equal
SQL
-3 votes403 views8 answers
Sql to c# linq converter online
SQL