602SQL Documentation Index  

DROP GROUP Statement

statement_DROP_GROUP ::= DROP [ IF EXISTS ] GROUP group_name


The DROP GROUP statement deletes a group with the specified name. Users assigned to this group are not deleted when calling the DROP GROUP statement.

If the group of the specified name does not exist on the database, the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

Only the security or configuration administrator may delete a group.


Deletes the XUSER user and the XGROUP group.

DROP USER xuser;
DROP GROUP xgroup;