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

11 votes133 views2 answers
Having clause
SQL
0 vote131 views1 answer
Database springboot
SQL
0 vote138 views1 answer
Postgres add prefix to primary key
SQL
1 vote132 views1 answer
Launch sql script from docker in mysql
SQL
0 vote137 views1 answer
Postgresql find missing id
SQL
1 vote148 views1 answer
Oracle create as select
SQL
0 vote140 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote161 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
94 votes200 views4 answers
Create database postgres
SQL
1 vote153 views1 answer
Table valued functions in sql
SQL