Note
This view is introduced in V4.0.0.
Purpose
This view in the sys tenant displays the associations between all tables and table groups in the database. Tables not in any table group are not displayed.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| TABLEGROUP_NAME | VARCHAR2(128) | NO | Table group name |
| OWNER | VARCHAR2(128) | NO | Database name to which the table belongs |
| TABLE_NAME | VARCHAR2(256) | NO | Table name |
| SHARDING | varchar(10) | NO | SHARDING attribute of the table group:
|
Examples
Query the associations of the tblgroup1 table group in the sys tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_TABLEGROUP_TABLES WHERE tablegroup_name = 'tblgroup1';
The query result is as follows:
+-----------+-----------------+-------+------------+----------+
| TENANT_ID | TABLEGROUP_NAME | OWNER | TABLE_NAME | SHARDING |
+-----------+-----------------+-------+------------+----------+
| 1002 | tblgroup1 | test | tbl3 | ADAPTIVE |
| 1004 | TBLGROUP1 | SYS | TBL3 | NONE |
+-----------+-----------------+-------+------------+----------+
2 rows in set