-543 A ROW IN A PARENT TABLE CANNOT BE DELETED BECAUSE THE CHECK CONSTRAINT `check-constraint` RESTRICTS THE DELETION

Explanation
 The delete operation cannot be executed because
the target table is a parent table and is connected with a referential
constraint to a dependent table with a delete rule of SET NULL.  However,
a check constraint defined on the dependent table restricts the column
from containing a null value.

System action
 The DELETE statement was not executed. The contents
of the tables are unchanged.

Programmer response
 Examine the foreign key and its delete
rule in the dependent table and the conflicting check constraint.
Change either the delete rule or the check constraint so that they
do not conflict.

SQLSTATE
 23511

-543 A ROW IN A PARENT TABLE CANNOT BE DELETED BECAUSE THE CHECK CONSTRAINT check-constraint RESTRICTS THE DELETION

Explanation

System action

Programmer response

SQLSTATE

-543 A ROW IN A PARENT TABLE CANNOT BE DELETED BECAUSE THE CHECK CONSTRAINT `check-constraint` RESTRICTS THE DELETION