View (SQL): Difference between revisions

Revision as of 21:43, 29 May 2005

Revision as of 02:03, 30 May 2005

Line 1:

In [[database theory]], a '''view''' is a virtual or logical [[Table (database)|table]] composed of the result set of a pre-compiled [[query]]. Unlike ordinary 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 view alters the [[data]] stored in the [[database]]. See also [[stored procedure]].

{{compu-stub}}