Previous Next JavaScript must be enabled to correctly display this content

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