SQL Syntax Reference : DROP GROUP
 
DROP GROUP
This statement removes one or more groups in a secured database.
Syntax
DROP GROUP [ IF EXISTS ] group-name [ , group-name ]...
Remarks
Only the Master user can perform this statement. Separate multiple group names with a comma. A group must be empty to be dropped.
Security must be turned on to perform this statement.
The expression IF EXISTS causes the statement to return success instead of an error if a group does not exist. IF EXISTS does not suppress other errors.
Examples
The following example drops the group psqlgroup.
DROP GROUP psqlgroup
The following example uses a list to drop groups.
DROP GROUP psql_dev, psql_marketing
See Also
ALTER GROUP
CREATE GROUP