The SHOW GROUP statement returns a result set with information about the database tables and the existing tenants that are associated with one or more groups.

The SHOW GROUP statement uses the following syntax:

Syntax 

SHOW { ALL GROUP [{ FOR TABLE table_name | FOR TENANT tenant_name }]| 
     GROUP FOR group_name}     [ FULL | PRO_NAME ];

Examples: SHOW GROUP statement

The following example shows how to get the basic information about a specific group:

SHOW GROUP FOR customer_group3;

The following example shows how to get full information about all the groups defined for the pub.mtcustomer table:

SHOW ALL GROUP FOR TABLE pub.mtcustomer FULL;

The following example shows how to get information about all the groups that a tenant belongs to:

SHOW ALL GROUP FOR TENANT Consolidated_Freightways;

For more on the SHOW GROUP statement, see OpenEdge SQL Reference.