sp_drop_all_qplans

Deletes all abstract plans in an abstract plan group.

sp_drop_all_qplans name

name: is the name of the abstract plan group from which to drop all plans.

sp_drop_all_qplans dev_test

To drop individual plans, use sp_drop_qplan.
To see the names of abstract plan groups in the current database, use sp_help_qpgroup.
sp_drop_all_qplans silently drops all plans in the group that belong to the specified user, or all plans in the group, if it is executed by a system administrator or database owner.

The permission checks for sp_drop_all_qplans differ based on your granular permissions settings.

Granular permissions enabled

With granular permissions enabled, you must be a user with manage abstract plans privilege.

Any user can execute sp_drop_all_qplans to drop plans that they own.

Granular permissions disabled

With granular permissions disabled, you must be the database owner or a user with sa_role.

Any user can execute sp_drop_all_qplans to drop plans that they own.

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