Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : DBA use cases : Alter a tenant
 

Alter a tenant

To alter a tenant, regular_tenant, in a multi-tenant table:
ALTER TENANT regular_tenant
    FOR TABLE pub.finance_accts USING TABLE DEFAULT AREA
    FOR TABLE pub.new_customers USING TABLE AREA "MMN Data area"
                                USING INDEX AREA "MMN_Index_Area";