http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?action=history&feed=atom&title=Slide%2FSQL_DDL_ALTER_and_DROP
Slide/SQL DDL ALTER and DROP - Revision history
2026-08-07T10:13:28Z
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_DDL_ALTER_and_DROP&diff=574&oldid=prev
Sysop: modified through wikirestore by Sysop
2023-04-05T07:12:28Z
<p>modified through wikirestore by Sysop</p>
<p><b>New page</b></p><div>== Links ==<br />
<br />
* {{Link|target=lg/SQL-DDL-AlterDropTable|title=SQL-DDL-AlterDropTable}}<br />
<br />
* {{Link|target=keyword/SQL|title=SQL}}<br />
* {{Link|target=keyword/SQL Syntax|title=SQL Syntax}}<br />
* {{Link|target=keyword/ALTER|title=ALTER}}<br />
* {{Link|target=keyword/DROP|title=DROP}}<br />
<br />
<br />
<br />
== Links hierher ==<br />
{{WhatLinksHere}}<br />
<pdf page='26'>4-RelationaleDatenbankspracheSQL.pdf</pdf><br />
= Meta =<br />
{{Slide<br />
|qkey=SQL-26<br />
|pkey=SQL<br />
|basename=4-RelationaleDatenbankspracheSQL.pptx<br />
|page=26<br />
|pdf_page=26<br />
|name=SQL_DDL_ALTER_and_DROP<br />
|title=ALTER TABLE und DROP TABLE<br />
|keywords=SQL, SQL Syntax,ALTER,DROP<br />
|links=<br />
|literature=<br />
|learningGoal=lg/SQL-DDL-AlterDropTable<br />
|storemode=property<br />
}}<br />
= Text =<br />
<pre><br />
ALTER TABLE und DROP TABLE<br />
Relation ändern•Spalte hinzufügen, wobei •NOT NULL •nicht erlaubt ist•Neues Attribut wird mit Nullwerten belegt.•ALTER TABLE •<Relationenname>•ADD• <Attributname> <Typ> [•DEFAULT• <Ausdruck>]•Spalte entfernen • •ALTER TABLE •<Relationen-Name>•DROP COLUMN •<Attributname>•Relation löschen•DROP TABLE •<Relationenname><br />
<br />
<br />
</pre><br />
<headertabs/></div>
Sysop