Feature
This view displays the basic information of all tenants, including the sys tenant, user tenants, and Meta tenants. You can determine the tenant type based on the TENANT_TYPE column.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. Valid values: |
| TENANT_NAME | varchar(128) | NO | The tenant name. |
| TENANT_TYPE | varchar(4) | NO | The type of the tenant. Valid values: SYS: the sys tenant.USER: a user tenant.META: a Meta tenant. |
| CREATE_TIME | timestamp(6) | YES | The time when the tenant was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the tenant was modified. |
| PRIMARY_ZONE | varchar(128) | YES | The primary zone of the tenant. |
| LOCALITY | varchar(4096) | NO | The locality of the tenant. |
| PREVIOUS_LOCALITY | varchar(4096) | NO | The locality before the change. NULL: No locality change was performed. |
| COMPATIBILITY_MODE | varchar(6) | NO | The compatibility mode. Valid values: MYSQLORACLE |
| STATUS | varchar(64) | NO | The current status of the tenant. TENANT_STATUS_NORMAL: The tenant is normal.TENANT_STATUS_RESTORE: The tenant is undergoing physical recovery.TENANT_STATUS_CREATING: The tenant is being created.TENANT_STATUS_DROPPING: The tenant is being dropped. |
| IN_RECYCLEBIN | varchar(3) | NO | Indicates whether the tenant has been dropped and is in the recycle bin. Valid values: YES: The tenant is in the recycle bin.NO: The tenant is not in the recycle bin. |
| LOCKED | varchar(3) | NO | Indicates whether the tenant is locked. |