Empty all elements from the procedure cache in SQL Server

Removes all elements from the procedure cache.

Syntax
DBCC FREEPROCCACHE

Remarks
Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache would cause, for example, an ad-hoc SQL statement to be recompiled rather than reused from the cache.