SHOW GROUP
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:
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;
|
In this section:
