View (SQL): Difference between revisions

Revision as of 06:20, 27 December 2005

Revision as of 12:10, 27 December 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]].

'''Types of veiwsviews'''

VeiwsViews can be of three types Inline veiwsviews,database veiwsviews and materialised veiwsviews. Materialised veiwsviews are different from all in the sense that, it is sanpshota snapshot of a main database distributed over different geographical areas, a so called distributed databasesdatabase. It has permanent existence.

Other veiwsviews are created using SELECT operation for query processing.

== See also ==