SQL CREATE ALTER DROP VIEW: Difference between revisions
Jump to navigation
Jump to search
(→CREATE) |
|||
| (8 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)}} | |||
=<tt>CREATE</tt>= | =<tt>CREATE</tt>= | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
CREATE | CREATE VIEW cust_view AS SELECT id, name, address FROM customer; | ||
SELECT id, name, address FROM customer; | |||
</syntaxhighlight> | </syntaxhighlight> | ||
:{| class="wikitable" style="text-align: left;" | :{| class="wikitable" style="text-align: left;" | ||
| Line 16: | Line 19: | ||
=<tt>ALTER</tt>= | =<tt>ALTER</tt>= | ||
=<tt>DROP</tt>= | =<tt>DROP</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
CREATE
CREATE VIEW cust_view AS SELECT id, name, address FROM customer;