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

4 votes107 views1 answer
SQL order random
SQL
2 votes134 views2 answers
Postgresql get table names
SQL
0 vote111 views1 answer
Install ms sql server management studio
SQL
0 vote113 views1 answer
Inserted row count tsql
SQL
0 vote124 views1 answer
Show the colums of table sql
SQL
-1 vote128 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote120 views2 answers
Demmarrer un service mysql teminal cmd
SQL
2 votes145 views2 answers
How to run postgresql in linux
SQL
13 votes121 views6 answers
Mysql remove duplicates
SQL
4 votes145 views1 answer
Sql select limit range
SQL