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 vote363 views2 answers
Sql truncate number
SQL
3 votes359 views2 answers
How to start mysql in terminal
SQL
0 vote330 views6 answers
Unique key in sql
SQL
2 votes365 views1 answer
Mariadb json select
SQL
0 vote368 views1 answer
Modifier une valeur sql
SQL
0 vote353 views1 answer
How to access to mysql without root
SQL
0 vote375 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote339 views1 answer
Select all tables linked server sql
SQL
6 votes318 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote352 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL