Updated on 2024-06-03 GMT+08:00

DROP GROUP

Description

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

Precautions

DROP GROUP is an API of the GaussDB management tool. You are advised not to use this API, because doing so affects GaussDB.

Syntax

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.

Examples

See 8.12.8.25 - Example in section "CREATE GROUP."

Helpful Links

ALTER GROUP, CREATE GROUP, and DROP ROLE