Deletes a group from a multi-tenant database and deallocates the database resources in the group partition of the multi-tenant table for which the group is defined.
Syntax
DROP GROUP group_name;
Parameter
group_name
Specifies the name of the group that you want to delete from the multi-tenant database.
Example
The following example illustrates the DROP GROUP statement:
DROP GROUP carz_group;
Note
The specified group must be an existing valid group in the database. All the tenants must be disassociated from the group before dropping it.
