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 vote110 views1 answer
Sp in sql server
SQL
0 vote113 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote119 views1 answer
Calculer pourcentage mysql
SQL
0 vote94 views1 answer
Get all employee of salary if more than in sql
SQL
2 votes101 views4 answers
Check timezone of mysql database
SQL
0 vote105 views1 answer
Sql convert unix time to date
SQL
5 votes116 views1 answer
Oracle list functions
SQL
5 votes109 views1 answer
Sql table columns
SQL
1 vote105 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote97 views1 answer
Get who is hired in january in sql
SQL