drop_group7l
Remove a user group
Usage
DROP GROUP name
Inputs
- name
-
The name of an existing group.
Outputs
- DROP GROUP
-
The message returned if the group is successfully deleted.
Overview
DROP GROUP removes the specified group from the database. The users in the group are not deleted.
Use CREATE GROUP [create_group(l)] to add new groups, and ALTER GROUP [alter_group(l)] to change a group's membership.
Usage
To drop a group:
DROP GROUP staff;
Compatibility
SQL92
There is no DROP GROUP in SQL92.