Revision as of 20:49, 14 December 2017 edit Mindmatrix (talk \| contribs) Autopatrolled, Administrators 188,534 edits m Reverted edits by 219.91.153.22 (talk) to last version by 42.107.82.74 Tag: Rollback ← Previous edit		Revision as of 20:50, 14 December 2017 edit undo Mindmatrix (talk \| contribs) Autopatrolled, Administrators 188,534 edits undo latent vandalism Next edit →
Line 1: In a [[database]], a '''view''' is the [[result set]] of a ''stored'' [[Query language\|query]] on the [[data]], which the [[database]] users can query just as they would in a persistent database collection object. This pre-established query command is kept in the database dictionary. Unlike ordinary ''base tables'' in a [[relational database]], a view does not form part of the [[database design\|physical schema]]: as a result set, it is a virtual ~~tables~~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. In some [[NoSQL]] databases, views are the only way to query data. Views can provide advantages over tables:

View (SQL): Difference between revisions