DROP TABLEGROUP

Purpose

This statement is used to drop a tablegroup. However, if any table's TABLEGROUP attribute references the target tablegroup, the tablegroup cannot be dropped.

Syntax

DROP TABLEGROUP [IF EXISTS] tablegroup_name

Parameters

Examples

• Drop a tablegroup named Table_Group1.

  obclient> DROP TABLEGROUP Table_Group1;
  

• Drop a non-existent tablegroup Table_Group1.

  obclient> DROP TABLEGROUP Table_Group1;
  

  Expected return result:

  ERROR 5151 (42P01): tablegroup not exist
  

• Specify IF EXISTS to drop a non-existent tablegroup Table_Group1.

  obclient> DROP TABLEGROUP IF EXISTS Table_Group1;
  

References

• CREATE TABLEGROUP
• ALTER TABLEGROUP