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.

The ALTER GROUP statement uses the following syntax:

Syntax 

ALTER GROUP group_name {ADD | DROP} TENANT list_of_tenant_names

Example: Alter a group to add tenants

The following example illustrates the ALTER GROUP statement:

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

Example: Alter a group to drop tenants

The following example illustrates the ALTER GROUP statement:

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

For more on the ALTER TENANT statement, see OpenEdge SQL Reference.