Deletes a tenant from a multi-tenant database.

Syntax

DROP TENANT [owner_name]tenant_name;

Parameters

tenant_name

Specifies the name of the tenant you want to delete. The name of the tenant must exist in the database.

owner_name

Specifies the name of the schema which qualifies the table.

Notes

Each database contains users, domains, and tenants. A DBA must follow the order specified below to drop a tenant from the database:

  1. DROP USER for every user in the domain.
  2. DROP DOMAIN for every domain defined for the tenant.
  3. DROP TENANT.

Example

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

DROP TENANT pub.mtcustomer;

If a tenant that is being dropped belongs to one or more groups, it is first disassociated from the group(s) before being dropped.