Clear Plans for particular type of object in SQL Server

-- clear plans for a particular type of object

-- clear sql plans: adhoc sql, prepared statements

dbcc freesystemcache('SQL Plans');

-- clear object plans: stored procedures, functions, triggers

dbcc freesystemcache('Object Plans');

-- clear bound trees: views, constraints, defaults

dbcc freesystemcache('Bound Trees');

-- clear extended stored procedures

dbcc freesystemcache('Extended Stored Procedures');