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 Data Management: SQL Reference.
