内容阅读
在知识库中专注阅读，并随时返回相关工具与课程
在知识库中专注阅读，并随时返回相关工具与课程
Integrity constraint violated - child record found
对父表的 DELETE 或 UPDATE 会使通过外键约束引用父键的子记录成为孤儿记录。
SELECT c.table_name AS child_table, c.constraint_name, cc.column_name FROM dba_constraints c JOIN dba_cons_columns cc ON c.constraint_name = cc.constraint_name WHERE c.r_constraint_name = (SELECT constraint_name FROM dba_constraints WHERE table_name = 'PARENT_TABLE' AND constraint_type = 'P');