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 SQL Reference.