SHOW-INDEX
SHOW-INDEX​
Name​
SHOW INDEX
Description​
This statement is used to display information about indexes in a table.
grammar:
SHOW INDEX[ES] FROM [db_name.]table_name [FROM database];
or
SHOW KEY[S] FROM [db_name.]table_name [FROM database];
Example​
-
Display the lower index of the specified table_name
SHOW INDEX FROM example_db.table_name;
Keywords​
SHOW, INDEX