P3SQCm8K

1CONSTRAINT `fk_Tabel_RefererendeTabel1`
2FOREIGN KEY (`IDTabel`)
3REFERENCES `KnowledgeBase`.`RefererendeTabel` (`IDRefererendeTabel`)
4ON DELETE NO ACTION
5ON UPDATE NO ACTION
6
7dit onderaan de code van je tabel
8vb:
9CREATE TABLE IF NOT EXISTS `KnowledgeBase`.`Afspraak`
10(
11	`AfsID` INT NOT NULL AUTO_INCREMENT COMMENT '',
12	`IDCat` INT NOT NULL COMMENT '',
13	`Titel` TINYTEXT NOT NULL COMMENT '',
14	`Omschrijving` MEDIUMTEXT NULL COMMENT '',
15  PRIMARY KEY (`AfsID`),
16	CONSTRAINT `fk_Afpraak_Categorie1`
17    FOREIGN KEY (`IDCat`)
18    REFERENCES `KnowledgeBase`.`Categorie` (`CatID`)
19    ON DELETE NO ACTION
20    ON UPDATE NO ACTION
21)
22ENGINE = InnoDB;