sp_drop_all_qplans drops all abstract plans in a group. This example drops all abstract plans in the dev_plans group:
sp_drop_all_qplans dev_plans
When a System Administrator or the Database Owner executes sp_drop_all_qplans, all plans belonging to all users are dropped from the specified group. When another user executes this procedure, it affects only the plans owned by that users.
