| |
- Causa
- A ROW IN A PARENT TABLE CAN NOT BE DELETED BECAUSE THE CHECK CONSTRAINT check-constraint RESTRICTS THE DELETION.
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.
- Ação do sistema
- The DELETE statement was not executed.
The contents of the tables are unchanged.
- Resposta ao Desenvolvedor
- 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
© Copyright IBM Corp.
|
| |
