View (SQL)

This is an old revision of this page, as edited by Alai (talk | contribs) at 02:03, 30 May 2005 (stub-sort). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

In database theory, a view is a virtual or logical 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 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.