All Products
Search
Document Center

DROP TENANT

Last Updated: Jun 18, 2021

Description

You can execute the DROP TENANT statement to delete a tenant from the ApsaraDB for OceanBase system.

Syntax

drop_tenant_stmt:
    DROP TENANT [IF EXISTS] tenant_name;

Parameters

Parameter

Description

tenant_name

The name of the tenant that you want to delete.

Only a locked tenant can be deleted. If you execute this statement to delete an unlocked tenant, the system returns an error.

Examples

  • Delete tenant TENANT1.
DROP TENANT TENANT1;

Notes

Before you execute the DROP TENANT statement to delete a tenant, connect your root user to the root tenant root@ROOT.