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 vote267 views1 answer
Mariadb search columns
SQL
3 votes259 views2 answers
Mysql create timestamp column
SQL
0 vote279 views1 answer
How to select only a certain date sql
SQL
2 votes325 views2 answers
MySql FULL OUTER JOIN
SQL
2 votes252 views1 answer
Sqlite insert if not exists
SQL
0 vote279 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote243 views1 answer
INSERT INTO table using OpenQuery
SQL
7 votes247 views1 answer
Alter sequence set current value oracle
SQL
1 vote280 views1 answer
Sql set auto increment back to 0
SQL
0 vote264 views1 answer
Sql shell psql cannot enter password
SQL