View (SQL)

This is an old revision of this page, as edited by Fragment~enwiki (talk | contribs) at 20:27, 7 August 2005 (added de:-link). 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