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 vote133 views1 answer
How to pass list as parameter in SQL query
SQL
4 votes142 views2 answers
Oracle unliock account
SQL
2 votes101 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote113 views1 answer
Mysql shell set time_zone
SQL
4 votes101 views3 answers
Mysql varchar length
SQL
0 vote172 views1 answer
Mysql update table from select on another table
SQL
4 votes113 views1 answer
Oracle delete last row
SQL
0 vote109 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote120 views1 answer
Sample clause in sql
SQL
1 vote112 views3 answers
Default password of mysql
SQL