Cannot delete or update a parent row: a foreign key constraint fails

SELECT
TABLE_NAME,
COLUMN_NAME,
CONSTRAINT_NAME,
REFERENCED_TABLE_NAME,
REFERENCED_COLUMN_NAME
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE
REFERENCED_TABLE_NAME = 'SU001H';

posted @ 2023-09-10 00:27  侬侬发  阅读(10)  评论(0编辑  收藏  举报