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

2 votes113 views3 answers
Mysql pass command from command line
SQL
0 vote102 views1 answer
Transaction database with php
SQL
0 vote59 views1 answer
Update sql join multiple tables
SQL
0 vote177 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote106 views1 answer
Longtext sql
SQL
0 vote107 views1 answer
Postgres where
SQL
1 vote94 views1 answer
Sql alchemy with azuresql server
SQL
0 vote103 views3 answers
Above average salary in sql
SQL
1 vote93 views1 answer
Mysql datetime with timezone offset
SQL
0 vote95 views1 answer
Openquery join two tables
SQL