sp_drop_qplan drops individual abstract plans. This example drops the specified plan:
A System Administrator or Database Owner can drop any abstract plan in the database. Other users can drop only plans that they own.
To find abstract plan IDs, use sp_find_qplan to search for plans using a pattern from the query or plan, or sp_help_qpgroup to list the plans in a group.