Purpose
You can use this statement to drop an OceanBase Database tenant.
Notice
To execute this statement, you must log on to the
systenant 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;