O'Reilly logo

SQL: Visual QuickStart Guide by Chris Fehily

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Views

A view is a stored SELECT statement that returns a table whose data is 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 ends.

  • A view consists of a set of named columns and rows of data, so you can use it almost ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required