Drops an abstract plan.
sp_drop_qplan id
is the ID of the abstract plan to drop.
The abstract plan with the specified ID is dropped:
sp_drop_qplan 1760009301
To find the ID of a plan, use sp_help_qpgroup, sp_help_qplan, or sp_find_qplan. Plan IDs are also returned by create plan and are included in showplan output.
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
