Previous Next JavaScript must be enabled to correctly display this content

## SHOW INDEXES

You can retrieve a list of all indexes currently defined for a table using the `SHOW INDEXES` statement:

    SHOW [AS JSON] INDEXES ON table_name

where:

- AS JSON is optional and causes the resulting output to be JSON-formatted.

- table_name is the name of the table for which you want to list all the indexes.