Removes a group. The Control Plane cascades the removal: memberships are deleted and direct grants on the group are revoked.
DROP GROUP [IF EXISTS] <name>## Overview DROP GROUP removes a group and all of its memberships. Users who were members lose any roles that the group provided; users themselves are not affected by the drop. ## Behavior - Without IF EXISTS, dropping a non-existent group raises an error. With IF EXISTS, the operation succeeds silently. - Cascading removal: every group_members row referencing the group is deleted, and every role grant targeting the group is removed. - Users keep any other roles they hold directly or through other groups. Only privileges that came from this group are lost. ## Access Control Requires the `ManageUsers` privilege. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
name | Specifies the group to drop. | |
if_exists | Skip silently when the group does not exist. |
DROP GROUP old_team;DROP GROUP IF EXISTS old_team;