Data definition language: Difference between revisions

Content deleted Content added
m Mwtoews moved page Data definition language (SQL) to Data definition language over redirect: restore to previous name -- better to discuss this move on Talk page
No edit summary
Line 39:
</syntaxhighlight>
 
Some forms of ''CREATE TABLE DDL'' may incorporate DML ([[data manipulation language]])-like constructs, such as the ''CREATE TABLE AS SELECT'' (CTASCTaS) syntax of SQL.<ref>
{{cite book
| last = Allen
Line 53:
| isbn = 9781430232254
| pages = 90–91
| quote = The ''create table'' statement has a special syntax for creating tables from ''select'' statements. [...]: [...] ''create table foods2 as select * from foods;'' [...] Many other databases refer to this approach as ''CTASCTaS'', which stands for Create Table Asas Select, and that phrase is not uncommon among SQLite users.
}}
</ref>