Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Resolving Views

The process of combining a query on a view with its stored definition and translating it into a query on the view's underlying tables is called view resolution. Several problems can arise during this process. Be on the alert for issues arising from modifications of underlying tables or views:

• Adding columns to underlying tables or views for a view defined as SELECT * (SQL expands the asterisk shorthand at view creation, not at execution). A query of the view runs without an error message, but results don't include columns added to the underlying object after the view was created.

• Changing underlying tables or views by modifying column names or datatypes or by renaming or dropping the underlying objects. You'll probably get error ...