DROP TABLEGROUP

Purpose

You can use this statement to drop a table group. You cannot drop a table group that is referenced by the TABLEGROUP attribute of a table.

Syntax

DROP TABLEGROUP [IF EXISTS] tablegroup_name;

Parameters

Examples

• Create a table group named Table_Group1.

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

• Drop a nonexistent table group named Table_Group1.

  obclient> DROP TABLEGROUP Table_Group1;
  ERROR 5151 (42P01): tablegroup not exist
  

• Drop a nonexistent table group named Table_Group1 with IF EXISTS specified.

  obclient> DROP TABLEGROUP IF EXISTS Table_Group1;
  Query OK, 0 rows affected, 1 warning