DROP TABLEGROUP

Purpose

This statement is used to drop a tablegroup.

Privilege requirements

To execute DROP TABLEGROUP, you need the following privileges:

• You need the DROP privilege to drop a tablegroup.
• If the tablegroup contains tables, you need the ALTER privilege on those tables to modify their tablegroup attribute.

Considerations

• Dropping a tablegroup does not delete the tables within it, but it removes the association between the tables and the tablegroup.
• Before dropping a tablegroup, ensure that no business processes depend on it.

Syntax

DROP TABLEGROUP tablegroup_name

Parameters

Examples

Example 1: Drop a referenced tablegroup

When a tablegroup is referenced by tables through the TABLEGROUP attribute, you need to remove these references before dropping the tablegroup.

1. Attempting to drop a non-empty tablegroup will result in an error:

   obclient> DROP TABLEGROUP tblgroup1;
   

   Expected return result:

   OBE-00600: internal error code, arguments: -4615, tablegroup is not empty
   

2. View the tables in the tblgroup1 tablegroup:

   obclient> SHOW TABLEGROUPS;
   obclient> SHOW TABLES IN tblgroup1;
   

3. Remove the tbl1 table from the tblgroup1 tablegroup:

   obclient> ALTER TABLE tbl1 SET TABLEGROUP = '';
   

4. Drop the tblgroup1 tablegroup again:

   obclient> DROP TABLEGROUP tblgroup1;
   

Example 2: Complete tablegroup usage process

1. Create a tablegroup:

   obclient> CREATE TABLEGROUP tg1;
   

2. Create a table and specify the tablegroup:

   obclient> CREATE TABLE t1 (id INT) TABLEGROUP = tg1;
   

3. View the tablegroup information:

   obclient> SHOW TABLEGROUPS;
   

4. Remove the t1 table from the tg1 tablegroup:

   obclient> ALTER TABLE t1 SET TABLEGROUP = '';
   

5. Drop the tg1 tablegroup:

   obclient> DROP TABLEGROUP tg1;