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 Data Management: SQL Reference.
