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

3 votes578 views1 answer
Postgresql cast
SQL
0 vote347 views1 answer
How to check foreign key constraint in sql
SQL
0 vote284 views1 answer
Sql server select record with max id
SQL
8 votes237 views8 answers
Second highest salary in mysql
SQL
0 vote288 views1 answer
How to select all fieldsin a soql query
SQL
0 vote257 views1 answer
Selects all the columns from the sailors table
SQL
0 vote274 views1 answer
Android sqlite get rows count
SQL
0 vote290 views1 answer
Drop-toys-table
SQL
0 vote300 views1 answer
Copying query result to excel
SQL
1 vote280 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL