View (SQL): Difference between revisions

Revision as of 00:29, 21 January 2007

Revision as of 00:30, 21 January 2007

Line 1:

In [[database|database theory]], a '''view''' is a virtual or logical [[Table (database)|table]] composed of the result set of a [[SQL|query]]. Unlike ordinary tables (base tables) in a [[relational database]], a view is not part of the [[database design|physical schema]]: it is a dynamic, virtual table computed or collated from [[data]] in the [[database]]. Changing the [[data]] in a [[Table (database)|table]] alters the [[data]] shown in the view.

Views can provide advantages over tables;