Purpose
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
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. |
| 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.Valid values: |
| 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 | Comments |
| 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. |