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"]}