Slide/SQL FOREIGN KEY

Links

• SQL-DDL-ForeignKey

• SQL
• SQL Syntax
• FOREIGN KEY

Links hierher

Meta

Text

[edit]

Slide
edit
qkey	SQL-25
pkey	SQL
basename	4-RelationaleDatenbankspracheSQL.pptx
page	25
name	SQL_FOREIGN_KEY
title	FOREIGN KEY
keywords	SQL, SQL Syntax, FOREIGN KEY
links
literature
learningGoal	lg/SQL-DDL-ForeignKey→lg/SQL-DDL-ForeignKey

[edit]

FOREIGN KEY
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•.

Kunde (•KName•, KAdr, Saldo)•Lieferant (•LName•, •Ware•, LAdr, Preis)•Auftrag (•KName•, •LName•, •Ware•, Menge)