OceanBase Database

SQL - V4.4.2

Download PDF

oceanbase.DBA_OB_TABLEGROUP_TABLES

Last Updated:2026-09-03 07:31:12

Note

This view is available starting with V4.0.0.

Overview

Displays the relationships between table groups and tables of the current tenant. Tables that are not part of a table group are not displayed.

Columns

Field Name	Type	Whether can be NULL	Description
TABLEGROUP_NAME	varchar(128)	NO	Table group name
OWNER	varchar(128)	NO	The name of the database to which the table belongs.
TABLE_NAME	varchar(256)	NO	Table name
SHARDING	varchar(20)	NO	The SHARDING attribute of the table group: `NONE`: All partitions of all tables in the table group are placed on the same server, and there are no restrictions on which tables can be added to the table group. `PARTITION`: The data of each table in the table group is scattered by its partition. For a subpartitioned table, all subpartitions under a partition are aggregated together. `ADAPTIVE`: The data of each table in the table group is scattered in an adaptive manner. That is, if the tables in the table group are partitioned tables, they are scattered by partition; if the tables in the table group are subpartitioned tables, they are scattered by subpartition under each partition.
SCOPE	varchar(20)	NO	Table group`SCOPE`Attribute. Valid values: `SERVER`: Indicates that the leaders of all partition groups are distributed on the same node. `ZONE`: Indicates that the leaders of all partition groups are distributed within the same zone and are scattered across nodes within that zone. `CLUSTER`: Indicates that the leaders of all partition groups are scattered across nodes in the cluster. Note For V4.4.2, this field is available starting with V4.4.2 BP1.

References

Previous topic

oceanbase.DBA_OB_TABLEGROUP_SUBPARTITIONS

Next topic

oceanbase.DBA_OB_TABLEGROUPS

oceanbase.DBA_OB_TABLEGROUP_TABLES|V4.4.2|OceanBase Database|docs|OceanBase Documentations