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 vote235 views1 answer
Equi joins in oracle
SQL
8 votes240 views2 answers
Select table column name in sql
SQL
20 votes271 views4 answers
Sql count if
SQL
1 vote387 views2 answers
Sql unique rows
SQL
8 votes230 views1 answer
Insert a select statement into a table
SQL
3 votes241 views2 answers
Get current year sql
SQL
0 vote234 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote237 views2 answers
Plsql regex match whole word
SQL
4 votes225 views2 answers
Oracle unliock account
SQL
0 vote230 views1 answer
Commit transaction sql
SQL