Purpose
You can use this statement to drop an OceanBase Database 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 test_tenant1 tenant.
obclient> DROP TENANT test_tenant1;