Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with tenants : DROP TENANT
 
DROP TENANT
Deletes a tenant from a multi-tenant database.
If a tenant that is being dropped belongs to one or more groups, it is first disassociated from the group(s) before being dropped.
DROP TENANT [owner_name]tenant_name;
The following example shows how to drop the tenant, mtcustomer, from the multi-tenant table:
DROP TENANT pub.mtcustomer;
For more on the DROP TENANT statement, see OpenEdge Data Management: SQL Reference.