http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?action=history&feed=atom&title=Slide%2FSQL_CREATE_TABLE
Slide/SQL CREATE TABLE - Revision history
2026-07-28T19:12:58Z
Revision history for this page on the wiki
MediaWiki 1.39.1
http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?title=Slide/SQL_CREATE_TABLE&diff=648&oldid=prev
Sysop: modified through wikirestore by Sysop
2023-04-05T07:13:08Z
<p>modified through wikirestore by Sysop</p>
<p><b>New page</b></p><div>== Links ==<br />
<br />
* {{Link|target=lg/SQL-DDL-CreateTable|title=SQL-DDL-CreateTable}}<br />
<br />
* {{Link|target=keyword/DDL|title=DDL}}<br />
* {{Link|target=keyword/SQL|title=SQL}}<br />
* {{Link|target=keyword/SQL Syntax|title=SQL Syntax}}<br />
* {{Link|target=keyword/CREATE|title=CREATE}}<br />
* {{Link|target=keyword/NOT|title=NOT}}<br />
* {{Link|target=keyword/NULL|title=NULL}}<br />
* {{Link|target=keyword/CHAR|title=CHAR}}<br />
* {{Link|target=keyword/VARCHAR|title=VARCHAR}}<br />
* {{Link|target=keyword/DECIMAL|title=DECIMAL}}<br />
* {{Link|target=keyword/DEFAULT|title=DEFAULT}}<br />
* {{Link|target=keyword/UNIQUE|title=UNIQUE}}<br />
* {{Link|target=keyword/PRIMARY KEY|title=PRIMARY KEY}}<br />
* {{Link|target=keyword/primary key|title=primary key}}<br />
<br />
<br />
<br />
== Links hierher ==<br />
{{WhatLinksHere}}<br />
<pdf page='23'>4-RelationaleDatenbankspracheSQL.pdf</pdf><br />
= Meta =<br />
{{Slide<br />
|qkey=SQL-23<br />
|pkey=SQL<br />
|basename=4-RelationaleDatenbankspracheSQL.pptx<br />
|page=23<br />
|pdf_page=23<br />
|name=SQL_CREATE_TABLE<br />
|title=Die DDL von SQL - CREATE TABLE<br />
|keywords=DDL, SQL, SQL Syntax, CREATE, NOT, NULL, CHAR, VARCHAR, DECIMAL, DEFAULT, UNIQUE, PRIMARY KEY, primary key<br />
|links=<br />
|literature=<br />
|learningGoal=lg/SQL-DDL-CreateTable<br />
|storemode=property<br />
}}<br />
= Text =<br />
<pre><br />
Die DDL von SQL: •CREATE TABLE<br />
Das konzeptionelle Schema einer Datenbank wird durch die Data Definition Language (•DDL•) spezifiziert.•Relation anlegen•CREATE TABLE •<Relationenname> (<Spaltendefinition>{, <Spaltendefinition>})•mit <Spaltendefinition> ::= <Attributname> <Typ> {<Option>}•und <Option> ::= •DEFAULT• <Ausdruck> | •NOT NULL• | •UNIQUE• | •PRIMARY KEY •| …•Beispiel: •Kunde (•KName•, KAdr, Saldo)• CREATE TABLE Kunde• ( KName CHAR (20) NOT NULL,• KAdresse VARCHAR (50),• Saldo DECIMAL (7))<br />
<br />
<br />
</pre><br />
<headertabs/></div>
Sysop