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 vote193 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote222 views1 answer
Database db connection string format
SQL
1 vote193 views1 answer
Oracle add proxy
SQL
0 vote196 views2 answers
Sql query inner join 3 tables
SQL
21 votes263 views6 answers
Update sql
SQL
2 votes196 views2 answers
Create empty table from existing table
SQL
3 votes179 views1 answer
Search for column name in psql
SQL
8 votes188 views1 answer
Today minus 15 days postgresql
SQL
20 votes184 views2 answers
Counting in sql
SQL
1 vote212 views1 answer
Oracle split string
SQL