Answers for "display index in sql"

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

Browse Popular Code Answers by Language