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:

SHOW ALL TENANT FOR TABLE pub.mtcustomer;