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 dropped.

  Value range: an existing role name.

Examples

See Examples in "CREATE ROLE."

Helpful Links

CREATE GROUP, ALTER GROUP, and DROP ROLE