SQL CREATE ALTER DROP VIEW: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
 
(6 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>=
Line 17: Line 21:


=<tt>DROP</tt>=
=<tt>DROP</tt>=
<syntaxhighlight lang='sql'>
DROP TABLE person [...]
</syntaxhighlight>
:{| class="wikitable" style="text-align: left;"
|-
| [[PostgreSQL_DDL_Operations#Drop_a_Table|PostgreSQL]] || [[MySQL_DDL_Operations#Drop_Table|MySQL]]
|-
|}
=Features=
==<tt>AUTO_INCREMENT</tt>==
{{Internal|SQL_AUTO_INCREMENT#Overview|<tt>AUTO_INCREMENT</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