SQL CREATE ALTER DROP VIEW: Difference between revisions
Jump to navigation
Jump to search
Tag: Reverted |
Tag: Reverted |
||
| Line 4: | Line 4: | ||
=Overview= | =Overview= | ||
A '''view''' is a query that is stored in the database's [[SQL#Data_Dictionary|data dictionary]]. | A '''view''', or a '''virtual table''', is a query that is stored in the database's [[SQL#Data_Dictionary|data dictionary]]. It looks and acts like a table, but there is no data associated with the view. | ||
=<tt>CREATE</tt>= | =<tt>CREATE</tt>= | ||
Revision as of 17:26, 23 May 2024
Internal
Overview
A view, or a virtual table, is a query that is stored in the database's data dictionary. It looks and acts like a table, but there is no data associated with the view.
CREATE
CREATE VIEW cust_view AS SELECT id, name, address FROM customer;