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.