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 vote192 views1 answer
Define a variable in mysql from select
SQL
2 votes177 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote180 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote194 views1 answer
Delete hangfire retries list
SQL
1 vote167 views1 answer
Oracle apex prevent initial load
SQL
2 votes181 views1 answer
Postgresql change value in column
SQL
0 vote166 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote166 views1 answer
Update view sql
SQL
0 vote163 views1 answer
Renombrar tabla mysql
SQL
1 vote189 views1 answer
Sql group by sum with condition
SQL