oceanbase.CDB_OB_TABLEGROUPS

Overview

The system tenant displays the meta information of table groups for all tenants, primarily showing the partition information of the table groups.

Columns

Sample query

1. Create a table group named tblgroup1.

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

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

   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

About table groups