# SHOW WORKSPACES

Returns information on workspaces.

## Syntax

```
SHOW WORKSPACES [ IN GROUP { ID '<group_ID>' | '<group_name>' } ]
    [ LIKE '<pattern>' ] [ EXTENDED ]
    [ ORDER BY '<key>' [ ASC | DESC ],... ] [ LIMIT <limit> ]
```

## Arguments

* `group_ID`, `group_name`: The ID or name of the deployment (workspace group) that contains the workspace.
* `pattern`: Specifies a pattern similar to the SQL `LIKE` clause and returns workspaces 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.
* Specify the `EXTENDED` clause to return more information on the files.

## Example

The following command returns information on all the workspaces in the workspace group named **s2wsg** and sorts the result by `Name` in the ascending order:

```sql
SHOW WORKSPACES IN GROUP 's2wsg' EXTENDED ORDER BY Name;
```

***

Modified at: February 13, 2025

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

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