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.

SHOW [ ALL TENANT | TENANT FOR tenant_name][ FOR TABLE table_name ]  
     [ FULL | PRO_NAME | TABLE | TABLE INDEX ];

The following example shows how to drop the tenant, mtcustomer, from the multi-tenant table:

SHOW ALL TENANT FOR TABLE pub.mtcustomer;

For more on the SHOW TENANT statement, see OpenEdge SQL Reference.