CREATE GROUP

SQL Development

OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with groups : CREATE GROUP

CREATE GROUP

The CREATE GROUP statement creates a group for the specified table in a multi-tenant database and uses the following syntax:

Syntax

CREATE GROUP group_name FOR TABLE table_name TABLE AREA area_name_1
     [ INDEX AREA area_name_2]
     [ LOB AREA area_name_3]
  [ PRO_DESCRIPTION value]

Example: CREATE GROUP statement

The following example shows how to create a group for the pub.customer table and allocate partition space for table, index, and LOB:

CREATE GROUP carz_second FOR TABLE pub.customer TABLE AREA "CUSTTABAREA"
                                                INDEX AREA "CUSTIDAREA"
                                                LOB AREA "CUSTTLOBAREA"
     PRO_DESCRIPTION "Second Group for CARZ"

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