Purpose
You can use this statement to drop an OceanBase tenant.
Notice
To execute this statement, you must log on to the sys tenant as the root user.
Syntax
drop_tenant_stmt:
DROP TENANT [IF EXISTS] tenant_name [PURGE|FORCE];
Parameters
| Parameter | Description |
|---|---|
| tenant_name | The name of the tenant to be dropped. |
| PURGE | Drops the tenant after a delay. The dropped tenant is not placed into the recycle bin regardless of whether the recycle bin feature is enabled. |
| FORCE | Immediately drops the tenant regardless of whether the recycle bin feature is enabled. |
Examples
Drop the tenant named test_tenant1.
obclient> DROP TENANT test_tenant1;
