Creating or Dropping a Group Using DQL

Privileges required to Create or Drop a group : Create Group or Sysadmin or Superuser

Below is the query to create Group using DQL

Syntax

CREATE GROUP <GROUP NAME>
WITH ADDRESS '<EMAIL ADDRESS>'

Example

CREATE GROUP dctmgurusgrp
WITH ADDRESS '[email protected]'

Below we are querying to confirm it

Below is the query to Drop/Delete a Group using DQL

Syntax

DROP GROUP <GROUP NAME>

Example

DROP GROUP dctmgurusgrp