Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ SQL Reference/ SQL Syntax/ D/ DROP GROUP
Updated on 2025-08-19 GMT+08:00
View PDF

DROP GROUP

Description

Deletes a user group. DROP GROUP is an alias for DROP ROLE.

Precautions

It is available only to users with the CREATE ROLE permission granted by the administrator.

Syntax

1
 
DROP GROUP [ IF EXISTS ] group_name [, ...];

Parameters

  • IF EXISTS

    If a role does not exist, no error is reported. Instead, a notification is sent, indicating that the role does not exist.

  • group_name

    Specifies the name of the role to be deleted.

    Value range: an existing role name.

Helpful Links

CREATE GROUP, ALTER GROUP, and DROP ROLE

Parent topic: D