DROP TABLEGROUP (AUTO mode)-PolarDB(PolarDB)-阿里云帮助中心

Drops a tablegroup from an AUTO mode database. A tablegroup can only be dropped if it contains no tables.

This statement applies only to AUTO mode databases.

Syntax

DROP TABLEGROUP [IF EXISTS] tablegroup_name

Parameter	Description
`IF EXISTS`	Optional. Prevents an error from occurring if the specified tablegroup does not exist.
`tablegroup_name`	The name of the tablegroup to drop.

Drop a tablegroup

DROP TABLEGROUP test_tg;

Drop a tablegroup if it exists

DROP TABLEGROUP IF EXISTS test_tg;