Answers for "list all indexes mysql"

SQL
3

show indexes mysql

SHOW INDEX FROM yourtable;
Posted by: Guest on May-20-2020
1

check all indexes on table

SELECT
    tablename,
    indexname,
    indexdef
FROM
    pg_indexes
WHERE
    schemaname = 'yourschema' and tablename='yourtable'
ORDER BY
    tablename,
    indexname;
(POSTRGRESQL)
Posted by: Guest on June-15-2020
0

list index mysql cli

SHOW INDEX FROM table_name FROM db_name;
Posted by: Guest on August-12-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language