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

• Drop a table group named TableGroup1.

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

• Drop a nonexistent table group named TableGroup1.

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

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

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