oceanbase.CDB_OB_TABLEGROUPS

Purpose

This view displays metadata about all table groups in all tenants in the system tenant, including the partitioning information of 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