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 vote285 views1 answer
Print sum of values sql
SQL
1 vote350 views2 answers
Oracle difference between two dates in seconds
SQL
8 votes350 views1 answer
Oracle add datafile to tablespace
SQL
1 vote316 views1 answer
Substr sql last character
SQL
0 vote327 views1 answer
Luu ckeditor vao mysql
SQL
8 votes355 views2 answers
Update sql server from another table
SQL
0 vote365 views1 answer
Java sql timestamp now
SQL
0 vote327 views2 answers
Sql query in dax power bi
SQL
0 vote331 views1 answer
How to move a column to different spot mysql
SQL
0 vote344 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL