Answers for "sql show index"

SQL
3

show indexes mysql

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

how to see which columns are indexxed mysql

SHOW INDEXES FROM table_name;
Posted by: Guest on May-05-2020
0

display index in sql

SHOW INDEX FROM yourtable;
Posted by: Guest on April-20-2021
0

display index in sql

SELECT DISTINCT
    TABLE_NAME,
    INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';
Posted by: Guest on April-20-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language