DROP TABLEGROUP

Purpose

This statement is used to drop a table group.

Privilege requirements

To execute DROP TABLEGROUP, you need the following privileges:

• You must have the DROP privilege to drop a table group.
• If the table group contains tables, you need the ALTER privilege on those tables to modify their table group attributes.

Considerations

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

Syntax

DROP TABLEGROUP tablegroup_name

Parameters

Examples

Example 1: Drop a referenced table group

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

1. Attempting to drop a non-empty table group 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 table group:

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

3. Remove the tbl1 table from the tblgroup1 table group:

   obclient> ALTER TABLE tbl1 SET TABLEGROUP = '';
   

4. Drop the tblgroup1 table group again:

   obclient> DROP TABLEGROUP tblgroup1;
   

Example 2: Complete table group usage process

1. Create a table group:

   obclient> CREATE TABLEGROUP tg1;
   

2. Create a table and specify the table group:

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

3. View the table group information:

   obclient> SHOW TABLEGROUPS;
   

4. Remove the t1 table from the tg1 table group:

   obclient> ALTER TABLE t1 SET TABLEGROUP = '';
   

5. Drop the tg1 table group:

   obclient> DROP TABLEGROUP tg1;