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:

DROP GROUP carz_group;