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

1 vote177 views1 answer
Oracle select first result
SQL
8 votes133 views1 answer
Similarities between ddl and dml
SQL
2 votes211 views3 answers
Row number mysql
SQL
5 votes177 views1 answer
Ignore duplicate rows in sqlite
SQL
5 votes170 views1 answer
Migrate sql table another database
SQL
0 vote173 views1 answer
How to retrive the today date sql
SQL
0 vote177 views1 answer
When mysql server would not work in xampp
SQL
0 vote188 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote207 views1 answer
Mysql 3 months ago
SQL
0 vote185 views1 answer
Mssql disable foreign key constraint
SQL