http://dbis-vl2.wikidata.dbis.rwth-aachen.de/index.php?action=history&feed=atom&title=Slide%2FSQL_FOREIGN_KEY 2026-04-25T15:59:00Z 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_FOREIGN_KEY&diff=546&oldid=prev 2023-04-05T07:12:13Z

<p>modified through wikirestore by Sysop</p> <p><b>New page</b></p><div>== Links ==<br /> <br /> * {{Link|target=lg/SQL-DDL-ForeignKey|title=SQL-DDL-ForeignKey}}<br /> <br /> * {{Link|target=keyword/SQL|title=SQL}}<br /> * {{Link|target=keyword/SQL Syntax|title=SQL Syntax}}<br /> * {{Link|target=keyword/FOREIGN KEY|title=FOREIGN KEY}}<br /> <br /> <br /> <br /> == Links hierher ==<br /> {{WhatLinksHere}}<br /> &lt;pdf page=&#039;25&#039;&gt;4-RelationaleDatenbankspracheSQL.pdf&lt;/pdf&gt;<br /> = Meta =<br /> {{Slide<br /> |qkey=SQL-25<br /> |pkey=SQL<br /> |basename=4-RelationaleDatenbankspracheSQL.pptx<br /> |page=25<br /> |pdf_page=25<br /> |name=SQL_FOREIGN_KEY<br /> |title=FOREIGN KEY<br /> |keywords=SQL, SQL Syntax, FOREIGN KEY<br /> |links=<br /> |literature=<br /> |learningGoal=lg/SQL-DDL-ForeignKey<br /> |storemode=property<br /> }}<br /> = Text =<br /> &lt;pre&gt;<br /> FOREIGN KEY<br /> Lieferant-Tabelle:•CREATE TABLE Lieferant•( LName CHAR (20) NOT NULL, Ware VARCHAR (20) NOT NULL, • LAdr VARCHAR (50), Preis DECIMAL (7), PRIMARY KEY (LName, Ware) )•Auftrag-Tabelle:•• CREATE TABLE Auftrag•( •KName• CHAR (20) NOT NULL •REFERENCES Kunde(KName)•, • Lname CHAR(20) NOT NULL,• Ware VARCHAR (20) NOT NULL, • Menge INTEGER, • PRIMARY KEY (KName, Lname, Ware),• FOREIGN KEY (Lname,Ware) REFERENCES Lieferant(Lname,Ware) •)•Wichtig:• •FOREIGN KEY •impliziert• NICHT• •PRIMARY KEY•.<br /> <br /> Kunde (•KName•, KAdr, Saldo)•Lieferant (•LName•, •Ware•, LAdr, Preis)•Auftrag (•KName•, •LName•, •Ware•, Menge)<br /> <br /> &lt;/pre&gt;<br /> &lt;headertabs/&gt;</div>

Sysop