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

14 votes381 views2 answers
Oracle limit rows
SQL
0 vote397 views1 answer
Sql select without column name
SQL
0 vote361 views1 answer
Sql select where more than one record exists
SQL
24 votes413 views6 answers
Sql change table name
SQL
0 vote392 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote382 views1 answer
Postrgres trunc
SQL
2 votes361 views1 answer
Oracle create directory
SQL
0 vote370 views1 answer
Pass array parameter to stored procedure c#
SQL
1 vote349 views1 answer
Postgres get timestamp
SQL
0 vote360 views1 answer
Copy Table from SQL to CSV
SQL