# SHOW GROUPS

Shows the list of groups on a cluster.

## Syntax

```
SHOW GROUPS

```

**Output**

| Column   | Description |
| -------- | ----------- |
| `Groups` | Groups      |

## Remarks

* A user with the `SHOW METADATA` or `GRANT` permission can list all groups. Without these permissions, role visibility follows the general information schema access rules. Refer to [Accessing the Information Schema](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/accessing-the-information-schema.md) for more information.

## Example

```sql
SHOW GROUPS;

```

```output

+---------+
| Groups  |
+---------+
| group_0 |
+---------+
1 row in set (0.00 sec)

```

**Related Topics**

* [SHOW GROUPS FOR ROLE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-groups-for-role.md)
* [SHOW GROUPS FOR USER](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-groups-for-user.md)

***

Modified at: May 12, 2026

Source: [/db/v9.1/reference/sql-reference/security-management-commands/show-groups/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/show-groups/)

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