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.