Note
This view is available starting with V4.0.0.
Purpose
This view displays the association between tables and table groups in all tenants under the sys tenant. Tables not in a table group are not displayed.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| TABLEGROUP_NAME | VARCHAR2(128) | NO | The name of the table group. |
| OWNER | VARCHAR2(128) | NO | The name of the database to which the table belongs. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the table. |
| SHARDING | varchar(20) | NO | The SHARDING attribute of the table group.
|
| SCOPE | varchar(20) | NO | The SCOPE attribute of the table group. Valid values:
NoteThis field is available starting with V5.0.1 for V5.x versions. |
Sample query
In the sys tenant, query the association of the table group named tblgroup2.
obclient> SELECT * FROM oceanbase.CDB_OB_TABLEGROUP_TABLES
WHERE tablegroup_name = 'tblgroup2'
AND TENANT_ID = '1002';
The return result is as follows:
+-----------+-----------------+---------+------------+----------+--------+
| TENANT_ID | TABLEGROUP_NAME | OWNER | TABLE_NAME | SHARDING | SCOPE |
+-----------+-----------------+---------+------------+----------+--------+
| 1002 | tblgroup2 | test_db | test_tbl3 | NONE | SERVER |
| 1002 | tblgroup2 | test_db | test_tbl4 | NONE | SERVER |
+-----------+-----------------+---------+------------+----------+--------+
2 rows in set