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-15 Show Indexes
The following statement lists the
indexes present on the UserInfo
table.
SHOW INDEXES ON UserInfo
Output:
indexes
idx_phones
idx_income1
Example 8-16 Show Indexes
The following statement lists the
indexes present on the UserInfo
table in JSON
format.
SHOW AS JSON INDEXES ON UserInfo
Output:
{"indexes"
: ["idx_phones","idx_income1"]}