Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with groups : ALTER GROUP
 
ALTER GROUP
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 Data Management: SQL Reference.