Overview
gv$table displays the metainformation of all tables in the cluster.
Related tables/views
oceanbase.__all_table_v2
oceanbase.__all_tenant
oceanbase.__all_database
oceanbase.__all_tablegroup
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. |
| table_id | BIGINT(20) | No | The ID of the table. |
| table_name | varchar(128) | No | The name of the table. |
| database_id | BIGINT(20) | No | The ID of the database. |
| database_name | varchar(128) | No | The name of the database. |
| tablegroup_id | BIGINT(20) | No | The ID of the table group to which the table belongs. |
| tablegroup_name | varchar(128) | No | The name of the table group to which the table belongs. |
| table_type | BIGINT(20) | No | The type of the table. |
| zone_list | varchar(8192) | No | The set of zones in the locality of the table. |
| primary_zone | varchar(128) | Yes | The primary zone of the table. |
| collation_type | BIGINT(20) | No | The collation type of the table. |
| locality | varchar(256) | No | The locality of the table. |
| schema_version | BIGINT(20) | No | The schema version. |
| read_only | BIGINT(20) | No | Indicates whether the table is read-only. |
| comment | varchar(4096) | No | The comment. |
| index_status | BIGINT(20) | No | The status of the index. |
| index_type | BIGINT(20) | No | The type of the index. |
| part_level | BIGINT(20) | No | The type of the partitioned table. |
| part_func_type | BIGINT(20) | No | The partitioning type. |
| part_func_expr | varchar(4096) | No | The expression for the partitioning function. |
| part_num | BIGINT(20) | No | The number of partitions. |
| sub_part_func_type | BIGINT(20) | No | The subpartitioning type. |
| sub_part_func_expr | varchar(4096) | No | The expression for the subpartitioning function. |
| sub_part_num | BIGINT(20) | No | The number of subpartitions. |
| dop | BIGINT(20) | No | The degree of parallelism of queries. |