DROP GROUP -- Removes a group
DROP GROUP name
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.