As a database changes, you can optimize the original query plans used to access its tables by recompiling them. This saves you from having to find, drop, and re-create every stored procedure and trigger.
This example marks every stored procedure and trigger that accesses the table titles to be recompiled the next time it is executed.
sp_recompile titles
See the Reference Manual: Procedures.