Returns specific information for a tenant. The information includes type and status of the tenant. If the tenant type is default, the SHOW TENANT statement displays the tenant ID as zero.
Syntax
SHOW [ ALL TENANT | TENANT FOR tenant_name][ FOR TABLE table_name ] [ FULL | PRO_NAME | TABLE | TABLE INDEX ];
Parameters
SHOW ALL TENANT
Returns information about the database objects for the defined tenants.
SHOW TENANT FOR tenant_name
Returns information about the database objects for the specified tenant.
FOR TABLE table_name
Returns information about the tenant in the specified table. If the specified table is not a multi-tenant table, it does not return any rows in the result set.
FULL
Returns complete information about the database objects for the specified tenant.
PRO_NAME
Returns the names of tenants in the multi-tenant table.
TABLE
Returns information about the table associated with the specified tenant.
TABLE INDEX
Returns information about the table and index defined for the multi-tenant tables associated with a specified tenant.
Example
The example shows how to return the available tenants of a table mtcustomer:
