Name
DROP GROUP
-- Removes a group
Synopsis
DROP GROUP name
Inputs
- name
The name of an existing group.
Outputs
- DROP GROUP
The message returned if the group is successfully deleted.
Description
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.
Usage
To drop a group:
DROP GROUP staff;
Compatibility
SQL92
There is no DROP GROUP in SQL92.