The DROP GROUP statement deletes a group from a multi-tenant database. It deallocates the database resources in the group partition of the multi-tenant table for which the group is defined. All the tenants must be disassociated from the group before dropping it.
The DROP GROUP statement uses the following syntax:
Syntax
DROP GROUP group_name;
Example: DROP GROUP statement
The following example shows how to delete a group from a multi-tenant database:
