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 vote286 views1 answer
Mysql conf.d exampel
SQL
0 vote310 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote295 views1 answer
Postgresql combine values in one field
SQL
0 vote289 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote265 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote264 views1 answer
Get all employees if name ends with in sql
SQL
1 vote292 views1 answer
Mysql tables max count
SQL
0 vote277 views1 answer
Sql query to check if column contains alphabets
SQL
28 votes325 views6 answers
Sql update
SQL
0 vote304 views1 answer
What is SQL data store?
SQL