Drop a table group

Before you drop a table group, make sure that it contains no table. Specifically, you can drop the table from the table group or clear the table group attribute of the table.

Syntax

DROP TABLEGROUP [IF EXISTS] tablegroup_name;

Parameters

Examples

1. View the tpcc_group table group.

   obclient> SHOW TABLEGROUPS;
   +-----------------+------------+---------------+
   | Tablegroup_name | Table_name | Database_name |
   +-----------------+------------+---------------+
   | oceanbase       | NULL       | NULL          |
   | tpcc_group      | ordr       | test          |
   +-----------------+------------+---------------+
   2 rows in set
   

2. Try to drop the tpcc_group table group.

   obclient> DROP TABLEGROUP tpcc_group;
   ERROR 4615 (HY000): tablegroup is not empty
   

   Note

   If this table group contains a table, an error is returned when you drop the table group.

3. Remove the ordr table from the tpcc_group table group.

   obclient>ALTER TABLE ordr tablegroup='';
   Query OK, 0 rows affected
   

   Note

   You can use the DROP TABLE statement to drop the table from the table group.

4. Drop the tpcc_group table group again.

   obclient> DROP TABLEGROUP tpcc_group;
   Query OK, 0 rows affected
   

5. Check whether the tpcc_group table group has been dropped.

   obclient> SHOW TABLEGROUPS;
   +-----------------+------------+---------------+
   | Tablegroup_name | Table_name | Database_name |
   +-----------------+------------+---------------+
   | oceanbase       | NULL       | NULL          |
   +-----------------+------------+---------------+
   1 row in set