DROP GROUP

Description

Drops 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

  Reports a notice instead of an error if the specified 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
• DROP ROLE