Overview
gv$database displays the metainformation of all the databases in the cluster.
Related tables/views
oceanbase.__all_database
oceanbase.__all_tenant
Field description
| Field name | 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 | The comment. |
| 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. |