Joe Celko's SQL for Smarties, 3rd Edition

33.14. Recompile Static SQL after Schema Changes

In most implementations, static SQL is compiled in a host program with a fixed execution plan. If a database schema object is altered, execution plans based on that object have to be changed.

In older SQL implementations, if a schema object was dropped, the programmer had to recompile the queries that referred to it. The SQL engine was not required to do any checking, and most implementations did not. Instead, you could get a runtime error.

Even worse, you could have a scenario like this:

1.	Create table A
2.	Create view VA on table A
3.	Use view VA
4.	Drop table A
5.	Create a new table A
6.	Use view VA

What happens in step 6? That depended on your SQL product, but the results were not good. ...