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 vote123 views3 answers
Divide by zero error in sql
SQL
10 votes129 views4 answers
Inner join in update query mysql
SQL
0 vote129 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote109 views1 answer
Floor function in sql oracle
SQL
0 vote162 views1 answer
Mysql faster delete
SQL
0 vote123 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote124 views1 answer
How get data from database if id not found then search another column
SQL
1 vote136 views2 answers
Mysql add column tinyint default 0
SQL
3 votes130 views2 answers
How to force truncate a table in mysql
SQL
6 votes129 views3 answers
What is where in sql
SQL