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 votes274 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
2 votes309 views1 answer
Set column to not null mysql
SQL
0 vote286 views1 answer
Recursive query herarchical data sql server
SQL
0 vote308 views1 answer
Mysql sql select one day before
SQL
0 vote291 views1 answer
Mysql trim characters
SQL
0 vote322 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote313 views4 answers
Mysql count table rows
SQL
22 votes381 views1 answer
Mysql workbench
SQL
0 vote367 views1 answer
Mysl like insert a variable
SQL
0 vote318 views1 answer
Sql alter table add column if exists
SQL