ALTER TABLE "USERNAME"."TABLE1"
ADD (CONSTRAINT "TABLE1_FK" FOREIGN KEY("COL1")
REFERENCES "USERNAME"."TABLE2"("COL1")
ON DELETE CASCADE) 最后一行
ON DELETE CASCADE
表示级联删除在oem里编辑详细目录的约束选项里添加
ADD (CONSTRAINT "TABLE1_FK" FOREIGN KEY("COL1")
REFERENCES "USERNAME"."TABLE2"("COL1")
ON DELETE CASCADE) 最后一行
ON DELETE CASCADE
表示级联删除在oem里编辑详细目录的约束选项里添加
ALTER TABLE "USERNAME"."TABLE1"
ADD (CONSTRAINT "TABLE1_PK" PRIMARY KEY("COL1") )外键和级联 见 armyyd(不会游泳的猫)