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.