SHOW INDEXES Statement

The SHOW INDEXES statement provides the list of indexes present on the specified table.

Syntax

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

Semantics

If you want the output to be in JSON format, you can specify the optional AS JSON.

Example 8-12 Show Indexes

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

SHOW INDEXES ON UserInfo;
  
indexes
   indexdemo1

Example 8-13 Show Indexes

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

SHOW AS JSON INDEXES ON UserInfo;
  
{"indexes" : ["indexdemo1"]}