Drops an abstract plan.
is the ID of the abstract plan to drop.
The abstract plan with the specified ID is dropped:
To drop all abstract plans in a group, use sp_drop_all_qplans.
Any user can execute sp_drop_qplan to drop a plan he or she owns. Only the System Administrator or the Database Owner can drop plans owned by other others.
Commands create plan
System procedures sp_drop_all_qplans, sp_find_qplan, sp_help_qpgroup, sp_help_qplan