Chapter 1: System Procedures

sp_drop_qplan

Description

Drops an abstract plan.

Syntax

sp_drop_qplan id

Parameters

id: is the ID of the abstract plan to drop.

Examples

Example 1

The abstract plan with the specified ID is dropped:

sp_drop_qplan 1760009301

Usage

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.

Permissions

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.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect