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 vote209 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
32 votes236 views6 answers
Rename column mysql
SQL
0 vote201 views1 answer
Mysql query problems and solutions
SQL
7 votes195 views2 answers
MySQL IF without else
SQL
0 vote231 views2 answers
Wordpress change url after migration mysql query
SQL
1 vote194 views2 answers
Mysql current user
SQL
5 votes221 views1 answer
Oracle nls parameters
SQL
1 vote269 views2 answers
Intersect sql
SQL
0 vote205 views1 answer
Compare field sql server
SQL
1 vote191 views2 answers
Drop function in sql
SQL