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

1 vote145 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote152 views1 answer
Increasing font and zooming in mysql workbench
SQL
4 votes155 views1 answer
Mysql biginteger size
SQL
2 votes143 views2 answers
Mysql on duplicate key ignore
SQL
0 vote145 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote99 views1 answer
Update row in sqlite python
SQL
0 vote149 views1 answer
Mysql procedure between two tables
SQL
1 vote155 views1 answer
Sysdate in sql
SQL
0 vote134 views1 answer
Database springboot
SQL
0 vote235 views1 answer
ORA-00942
SQL