# SHOW WORKSPACE GROUPS

Returns information on workspace groups.

## Syntax

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

## Arguments

* `pattern`: Specifies a pattern similar to the SQL `LIKE` clause and returns workspace groups 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 workspace groups that match the specified pattern:

```sql
SHOW WORKSPACE GROUPS LIKE 'Marketing%' EXTENDED ORDER BY Name;
```

***

Modified at: February 13, 2025

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

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