View (SQL): Difference between revisions

Revision as of 08:21, 29 September 2024

Latest revision as of 10:04, 10 August 2025

Line 1:

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

{{More citations needed|date=December 2023}}

In a [[database]], a '''view''' is the [[result set]] of a stored [[Query language|query]] that presents a limited perspective of the database to a user.<ref name="mysql-views">{{cite web | url=https://dev.mysql.com/doc/refman/8.0/en/views.html | title=25.5 Using Views | author=<!--Not stated--> | date=2023-12-12 | website=MySQL | publisher=Oracle | access-date=2023-12-12 | quote=Views are stored queries that when invoked produce a result set. A view acts as a virtual table. | archive-url=httphttps://web.archive.org/web/20231123070115/http://dev.mysql.com:80/doc/refman/8.0/en/views.html | archive-date=2023-11-23 | url-status=live }}</ref> This pre-established query command is kept in the [[data 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<ref name="mysql-views" /> 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: