SQL CREATE ALTER DROP VIEW: Difference between revisions

From NovaOrdis Knowledge Base
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;
PostgreSQL MySQL

ALTER

DROP