# SHOW REGIONS

Returns a list of all the regions for the user.

## Syntax

```
SHOW REGIONS [ LIKE '<pattern>' ]
    [ ORDER BY '<key>' [ ASC | DESC ], ... ]
    [ LIMIT <limit> ]
```

## Arguments

* `pattern`: Specifies a pattern similar to the SQL `LIKE` clause and returns regions with names that match the specified pattern. Uses `%` as the wildcard character.
* `key`: Key used to sort the result set.
* `limit`: An integer value.&#x20;

## Remarks

* The `LIMIT` clause limits the number of results to the specified number.
* By default, the result is sorted in the ascending order.

## Example

The following command returns all the regions in the US and sorts the result in ascending order by `Name`.

```sql
SHOW REGIONS LIKE 'US%' ORDER BY Name;
```

***

Modified at: February 13, 2025

Source: [/cloud/reference/fusion-sql/show-regions/](https://docs.singlestore.com/cloud/reference/fusion-sql/show-regions/)

(An index of the documentation is available at /llms.txt)