Use sp_drop_all_qplans to drop 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 user.
