SQL: Visual Quickstart Guide, Second Edition

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 SELECT statement, 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 ...