DROP GROUP name
The name of an existing group.
The message returned if the group is successfully deleted.
DROP GROUP removes the specified group from the database. The users in the group are not deleted.
Use CREATE GROUP to add new groups, and ALTER GROUP to change a group's membership.
To drop a group:
DROP GROUP staff;
There is no DROP GROUP in SQL92.