Chapter 13. Views
A view is a stored
SELECT statement that returns a table whose data are derived from one or more other tables (called underlying tables). Some important characteristics of a view are:
A view’s underlying tables can be base tables, temporary tables, or other views.
A view is called a virtual or derived table to distinguish it from a base or temporary table.
The DBMS stores a view as only a
SELECTstatement, not as a set of data values, thus preventing data redundancy.
A view materializes dynamically as a physical table when referenced by name in an SQL statement. It exists only for the duration of the statement and vanishes when the statement finishes.
A view is a set of named columns and rows of data, so you can use it almost anywhere ...