DROP GROUP

Applies to: check marked yes Databricks SQL

Drops a workspace-local group. An exception is thrown if the group does not exist in the system.

Workspace-local groups are not synchronized to the Databricks account and are not compatible with Unity Catalog. For more information, see Manage workspace-local groups (legacy).

Syntax

DROP GROUP group_principal

Parameters

group_principal

The name of the existing workspace-local group to drop.

Examples

-- Create `aliens` Group
> CREATE GROUP aliens WITH GROUP tv_aliens;

-- Drop `aliens` group
> DROP GROUP aliens;