SQL CREATE ALTER DROP VIEW: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 17: Line 17:


=<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=
=Features=
==<tt>AUTO_INCREMENT</tt>==
==<tt>AUTO_INCREMENT</tt>==
{{Internal|SQL_AUTO_INCREMENT#Overview|<tt>AUTO_INCREMENT</tt>}}
{{Internal|SQL_AUTO_INCREMENT#Overview|<tt>AUTO_INCREMENT</tt>}}

Revision as of 17:23, 23 May 2024

Internal

Overview

CREATE

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

ALTER

DROP

Features

AUTO_INCREMENT

AUTO_INCREMENT