Purpose
gv$database displays the metadata of all databases in the cluster.
Related tables/views
oceanbase.__all_database
oceanbase.__all_tenant
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| tenant_name | varchar(128) | NO | The name of the tenant. |
| database_id | bigint(20) | NO | The ID of the database. |
| database_name | varchar(128) | NO | The name of the database. |
| zone_list | varchar(8192) | NO | The set of zones in the locality of the database. |
| primary_zone | varchar(128) | YES | The primary zone of the database. |
| collation_type | bigint(20) | NO | The collation type of the database. |
| comment | varchar(2048) | NO | Comments |
| read_only | bigint(20) | NO | Indicates whether the view is read-only. |
| default_tablegroup_id | bigint(20) | NO | The ID of the default table group of the database. This field is used in table creation. If the value of this field is -1, no table group is specified for the database. |
| in_recyclebin | bigint(20) | NO | Indicates whether the database has been dropped and is in the recycle bin. |