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

0 vote87 views3 answers
Mysql calculate age from date of birth
SQL
11 votes126 views1 answer
Sql query to find duplicates in column
SQL
20 votes120 views5 answers
Sql show tables
SQL
0 vote125 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote118 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote118 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote132 views1 answer
Creation d'un trigger sql
SQL
0 vote133 views1 answer
Mysql cast null to string
SQL
1 vote78 views1 answer
Mssql string length
SQL
10 votes151 views4 answers
Inner join in update query mysql
SQL