Lists groups in the catalog, optionally filtered by a LIKE pattern.
SHOW GROUPS [LIKE '<pattern>']## Overview SHOW GROUPS returns a row per group with its name, member count, comment, and creation timestamp. ## Output | Column | Description | |--------|-------------| | name | Group name | | member_count | Number of users currently in the group | | comment | Description, if set | | created_at | ISO 8601 timestamp | ## Access Control Requires the `ManageUsers` privilege. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
pattern | Optional LIKE pattern. |
SHOW GROUPS;SHOW GROUPS LIKE '%_team';