SQL CREATE ALTER DROP VIEW: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Tag: Reverted
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
* [[SQL#CADV|SQL]]
* [[SQL#CADV|SQL]]
* [[SQL_Data_Types#Overview|SQL Data Types]]
* [[SQL_Data_Types#Overview|SQL Data Types]]
=TODO=
<font color=darkkhaki>TO PROCESS: https://learning.oreilly.com/library/view/learning-sql-3rd/9781492057604/ch14.html</font>
=Overview=
=Overview=
 
{{Internal|SQL#Virtual_Table_(View)|Virtual Table (View)}}
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>=

Latest revision as of 00:20, 25 May 2024

Internal

TODO

TO PROCESS: https://learning.oreilly.com/library/view/learning-sql-3rd/9781492057604/ch14.html

Overview

Virtual Table (View)

CREATE

CREATE VIEW cust_view AS SELECT id, name, address FROM customer;
PostgreSQL MySQL

ALTER

DROP