Jump to content

View (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Acjelen (talk | contribs) at 21:43, 29 May 2005 (split off from View). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

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.