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.