DROP GROUP

Function

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 [, ...];

Parameter Description

• 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