The ALTER GROUP statement allows you to add existing tenants to an existing multi-tenant group that is defined for a multi-tenant table. It also allows you to drop a tenant from an existing group that is defined for a multi-tenant table.

The tenant that you want to add to the group should not be a part of the group that is being altered. The tenant that is part of a group for a particular table cannot be part of another group for the same table.

To drop a tenant from the group that you want to alter, you must ensure that the tenant is a part of that group. When a tenant is dropped from a group, all the tenant partitions for that table are created with NO SPACE.

When the tenant of a specified table joins a group, the tenant's existing partition for that table is removed. The tenant partition for the table (on which the current group being altered is defined) must have a NO SPACE attribute set.

Syntax

ALTER GROUP group_name {ADD | DROP} TENANT list_of_tenant_names
group_name
Specifies the name of the group that you want to alter.
ADD TENANT
Adds an existing tenant to an existing multi-tenant group that is defined for a multi-tenant table.
DROP TENANT
Drops an existing tenant from an existing multi-tenant group that is defined for a multi-tenant table.
list_of_tenant_names
Specifies the list of tenants that you want to add to or drop from an existing multi-tenant group.

Examples

The following example alters a group by adding tenants to it:

ALTER GROUP hyb-parkinglot-group ADD TENANT easy-cabs,green-cabs,city-cabs

The following example alters a group by dropping tenants from it:

ALTER GROUP hyb-parkinglot-group DROP TENANT easy-cabs,green-cabs,city-cabs