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
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.