sp_drop_qpgroup drops an abstract plan group.
The following restrictions apply to sp_drop_qpgroup:
Only a System Administrator or Database Owner can drop abstract plan groups.
You cannot drop a group that contains plans. To remove all plans from a group, use sp_drop_all_qplans, specifying the group name.
You cannot drop the default abstract plan groups ap_stdin and ap_stdout.
This command drops the dev_plans plan group:
sp_drop_qpgroup dev_plans
