Returns a result set with information about the database tables and the existing tenants that are associated with one or more groups.

Syntax

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

Parameters

SHOW ALL GROUP

Returns information about all the groups defined in the multi-tenant database.

FOR TABLE table_name

Returns information about all the groups defined for the specified table. Returns zero rows if the specified table is not a multi-tenant table.

FOR TENANT tenant_name

Returns information about all the groups that the tenant belongs to.

SHOW GROUP FOR group_name

Returns information about the specified group.

FULL

Returns all the information about all the groups defined for the specified table.

PRO_NAME

Returns only the names of the groups defined for the specified table.

Example

The following example shows how to return the basic information about all the groups defined in the database:

SHOW ALL GROUP;

The following example shows how to return all the group names defined for a table:

SHOW ALL GROUP FOR TABLE pub.mtcustomer PRO_NAME;

The following example shows how to get full information about all the groups defined for a 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;