DROP GROUP

Applies to: 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 Azure Databricks account and are not compatible with Unity Catalog. For more information, see Manage workspace-local groups (legacy).

To run this command you must be an administrator.

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;

Related articles

• SHOW GROUPS
• ALTER GROUP
• CREATE GROUP
• principal