Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

DROP GROUP

Info

SingleStore Managed Service does not support this command.

Remove a group from a SingleStore DB cluster.

Syntax

DROP GROUP [IF EXISTS] 'group_name'

Remarks

  • IF EXISTS is available in 6.0.15 or later.

Example

SHOW GROUPS;
+---------+
| Groups  |
+---------+
| group_0 |
+---------+
1 row in set (0.00 sec)

DROP GROUP 'group_0';
Query OK, 0 rows affected (0.22 sec)

SHOW GROUPS;
Empty set (0.00 sec)