86606693bfac70d44f.png (235.81 KB, 下载次数: 80)
2025-12-12 19:21 上传
原因是要删除OutpatientRegisterSource和OutpatientAppointSource表中的记录，但这些记录的主键还被OutpatientAppointSourceSno表的外键引用着，数据库为了保证数据完整性，拒绝了删除操作。也就是说，删除主表记录前，必须先清理引用表中指向该记录的外键数据，否则数据库会拒绝操作。
从报错信息可以明确：
1. OutpatientAppointSourceSno表通过外键Fk_OutpatientAppointSourceSno$OutpatientRegisterSourceId关联到OutpatientRegisterSource表的OutpatientRegisterSourceId
2. OutpatientAppointSourceSno表通过外键Fk_OutpatientAppointSourceSno$OutpatientAppointSourceId关联到OutpatientAppointSource表的OutpatientAppointSourceId
查看外键约束，可以发现：两个外键约束目前都没有配置级联删除（delete_rule是NO ACTION），这正是删除主表数据时报错的根本原因
92256693bfaddf35c9.png (141.92 KB, 下载次数: 77)
2025-12-12 19:22 上传
可以尝试通过修改外键约束，设置级联删除的方式解决
如果业务上希望删除主表记录时，自动删除子表的关联记录，可以修改外键约束，添加ON DELETE CASCADE（级联删除）（一切以业务为准）
-- 删除第一个外键约束
ALTER TABLE "OutpatientAppointSourceSno" DROP CONSTRAINT "Fk_OutpatientAppointSourceSno$OutpatientRegisterSourceId";
-- 删除第二个外键约束
ALTER TABLE "OutpatientAppointSourceSno" DROP CONSTRAINT "Fk_OutpatientAppointSourceSno$OutpatientAppointSourceId";
-- 重建第一个外键
ALTER TABLE "OutpatientAppointSourceSno" ADD CONSTRAINT "Fk_OutpatientAppointSourceSno$OutpatientRegisterSourceId" FOREIGN KEY ("OutpatientRegisterSourceId") REFERENCES "OutpatientRegisterSource" ("OutpatientRegisterSourceId") ON DELETE CASCADE;
-- 重建第二个外键
ALTER TABLE "OutpatientAppointSourceSno" ADD CONSTRAINT "Fk_OutpatientAppointSourceSno$OutpatientAppointSourceId" FOREIGN KEY ("OutpatientAppointSourceId") REFERENCES "OutpatientAppointSource" ("OutpatientAppointSourceId") ON DELETE CASCADE;
| 欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |