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 vote158 views1 answer
Oracle apex prevent initial load
SQL
0 vote167 views1 answer
Oracle change password expiration policy
SQL
0 vote192 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
1 vote195 views1 answer
Mysql current running queries
SQL
0 vote159 views2 answers
Check mysql timezone
SQL
0 vote163 views1 answer
Add unique constraint sql server multiple columns
SQL
1 vote228 views1 answer
Show databases mysql docker
SQL
0 vote170 views1 answer
Sql query to find duplicate email address
SQL
53 votes477 views6 answers
Sql server alter column
SQL
2 votes188 views1 answer
Oracle log files
SQL