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

10 votes177 views3 answers
Insert into auto increment mysql
SQL
0 vote204 views1 answer
Php select data from mysql database without column name
SQL
0 vote226 views1 answer
Mysql record group by created date count
SQL
3 votes200 views2 answers
Sql asc
SQL
0 vote194 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote196 views1 answer
Mysql uuid
SQL
0 vote218 views2 answers
Sql auto update dupdated_at
SQL
4 votes195 views1 answer
Find tables with column name in sql
SQL
4 votes193 views1 answer
SQL find text in SP
SQL
0 vote190 views1 answer
Date on SQL
SQL