View (SQL): Difference between revisions

Revision as of 05:47, 10 May 2023

Revision as of 19:31, 19 May 2023

Line 1:

{{Short description|Database stored query result set}}

{{Unreferenced|date=March 2020}}

In a [[database]], a '''view''' is the [[result set]] of a ''stored'' [[Query language|query]], which can be queried in the same manner as a persistent database collection object. This pre-established query command is kept in the [[databasedata dictionary]]. Unlike ordinary ''[[base table]]s'' in a [[relational database]], a view does not form part of the [[database design|physical schema]]: as a result set, it is a virtual table computed or collated dynamically from data in the database when access to that view is requested. Changes applied to the data in a relevant ''underlying table'' are reflected in the data shown in subsequent invocations of the view.

Views can provide advantages over tables: