show indexes

show_indexes_statement ::= SHOW [AS JSON] INDEXES ON table_name

The show indexes statement provides the list of indexes present on a specified table. The parameter AS JSON is optional and can be specified if you want the output to be in JSON format.

Example 1: List indexes on the specified table

The following statement lists the indexes present on the users2 table.

SHOW INDEXES ON users2;
indexes
   idx1

Example 2: List indexes on the specified table in JSON format

The following statement lists the indexes present on the users2 table in JSON format.

SHOW AS JSON INDEXES ON users2;
{"indexes" : 
     ["idx1"]
}