Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 2.3.1
- ALTER TABLE artikel ADD FOREIGN KEY (herstellernummer) REFERENCES hersteller (herstellernummer) ON DELETE CASCADE;
- (ALTER TABLE `artikel` ADD CONSTRAINT `artikel_ibfk_1` FOREIGN KEY (`herstellernummer`) REFERENCES `hersteller`(`herstellernummer`) ON DELETE CASCADE)
- SHOW INDEX FROM artikel;
- -- 2.3.2
- ALTER TABLE bestellung ADD FOREIGN KEY (artikelnummer) REFERENCES artikel (artikelnummer) ON DELETE CASCADE;
- ALTER TABLE bestellung ADD FOREIGN KEY (kundennummer) REFERENCES person (personennummer) ON DELETE CASCADE; SHOW INDEX FROM bestellung;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement