Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

display index in sql

SELECT DISTINCT
    TABLE_NAME,
    INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #display #index #sql
ADD COMMENT
Topic
Name
2+7 =