oceanbase.CDB_OB_TABLEGROUPS

Purpose

This view displays the metadata of all table groups of all tenants in the sys tenant. It mainly displays the partitioning information of the table groups.

Columns

Sample query

1. Create a table group named tblgroup1.

   obclient [test]> CREATE TABLEGROUP tblgroup1 SHARDING = 'PARTITION';
   

2. Query the SHARDING attribute of the tblgroup1 table group.

   obclient [test]> SELECT TABLEGROUP_NAME, SHARDING FROM oceanbase.CDB_OB_TABLEGROUPS WHERE tablegroup_name = 'tblgroup1';
   

   The query result is as follows:

   +-----------------+-----------+
   | TABLEGROUP_NAME | SHARDING  |
   +-----------------+-----------+
   | tblgroup1       | PARTITION |
   +-----------------+-----------+
   1 row in set
   

References

Table groups