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.