You can execute the SHOW INDEX statement to query the index information about a table.
Syntax
SHOW INDEX {FROM | IN} table_name;
Parameters
Parameter | Required | Description |
---|---|---|
table_name | Yes | The name of the table. |
Example
Query the index information about a table named exampletable.
SHOW INDEX IN exampletable;