CREATE TENANT

SQL Development

OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with tenants : CREATE TENANT

CREATE TENANT

The CREATE TENANT statement:

Defines a tenant for a multi-tenant database

Allocates database resources in the existing multi-tenant tables

Adds a new tenant to an existing multi-tenant group that is defined for a multi-tenant table

Syntax

CREATE TENANT tenant_name TABLE AREA area_name
  [ INDEX AREA area_name_2]
[ LOB AREA area_name_3]
  [ PRO_DESCRIPTION value]
  [ FOR TABLE [owner_name]table_name_1
{[ USING TABLE AREA table_area_name]
      [ USING INDEX AREA index_area_name]
      [ USING LOB AREA lob_area_name]    ]
| USING NO SPACE | JOIN GROUP group_name}]...
   [ FOR TABLE [owner_name]table_name_2[ USING NO SPACE ]]
;

Example: CREATE TENANT statement

The following example shows how to create a tenant by overriding an area for the selected table partition and how to add the tenant to a group:

CREATE TENANT Consolidated_Freightways TABLE AREA "CF Data area"
INDEX AREA "CF index area"
FOR TABLE pub.customer USING TABLE AREA "CF cust area"
USING INDEX AREA "CF cust idx area"
FOR TABLE pub.acct_payable USING TABLE AREA "CF Financial area"
USING INDEX AREA "CF Fin idx area"
FOR TABLE pub.farm_location USING NO SPACE
FOR TABLE pub.archive_10yr JOIN GROUP Joint_Archives;

Example: Creating a tenant and adding it to groups

The following example shows how to create a tenant and add it to multiple groups:

CREATE TENANT Consolidated_Freightways TABLE AREA "CF Data area"
FOR TABLE pub.farm_location JOIN GROUP AgriDataGroup
FOR TABLE pub.archive_10yr JOIN GROUP Joint_Archives;

For more on the CREATE TENANT statement, see OpenEdge Data Management: SQL Reference.