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

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

See also

Commands create plan

System procedures sp_drop_all_qplans, sp_find_qplan, sp_help_qpgroup, sp_help_qplan