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;