oceanbase.DBA_OB_TABLEGROUPS

Purpose

This view displays the metadata of a table group, including the partition information.

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.DBA_OB_TABLEGROUPS WHERE tablegroup_name = 'tblgroup1';
   

   The query result is as follows:

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

References

Table groups