Drops an abstract plan group.
sp_drop_qpgroup group
is the name of the abstract plan group to drop.
Drops the abstract plan group “dev_test”:
sp_drop_qpgroup dev_test
You cannot drop the default groups, ap_stdin and ap_stdout.
You cannot drop a group that contains plans. To drop all of the plans in a a group, use sp_drop_all_qplans. To see a list of groups and the number of plans they contain, use sp_help_qpgroup.
sp_drop_qpgroup cannot be run in a transaction.
Only a System Administrator or Database Owner can execute sp_drop_qpgroup.
System procedures sp_drop_all_qplans, sp_help_qpgroup
