Drops a group from a database.
is the name of a group in the current database.
The “purchasing” group has merged with the “accounting” group. These commands move “martha” and “george”, members of the “purchasing” group, to other groups before dropping the group. The group name “public” is quoted because “public” is a reserved word:
sp_changegroup accounting, martha sp_changegroup "public", george sp_dropgroup purchasing
Executing sp_dropgroup drops a group name from a database’s sysusers table.
You cannot drop a group if it has members. You must execute sp_changegroup for each member before you can drop the group.
Only the Database Owner, a System Administrator, or a System Security Officer can execute sp_dropgroup.
System procedures sp_addgroup, sp_changegroup, sp_helpgroup