Previous Next JavaScript must be enabled to correctly display this content

## show regions

    show_regions_statement ::= SHOW [AS JSON] REGIONS

The `show regions` statement provides the list of regions present in a multi-region Oracle NoSQL Database setup. The parameter `AS JSON` is optional and can be specified if you want the output to be in JSON format.

Example 1: Fetching all regions in a multi-region database setup

    SHOW REGIONS;
     regions
        my_region1 (remote, active)
        my_region2 (remote, active)

Example 2: Fetching all regions in a multi-region database setup in JSON format

    SHOW AS JSON REGIONS;
    {"regions" : [
        {"name" : "my_region1", "type" : "remote", "state" : "active"},
        {"name" : "my_region2", "type" : "remote", "state" : "active"}
    ]}