Cannot delete/truncate CK %2 because of RI violation — FK has non-nulls. %1
Item |
Value |
|---|---|
SQLCode |
-1009150 |
Constant |
EMSG_RI_VIOLATION_FKNOTNULL |
SQLState |
QSB46 |
ODBC State |
ERROR |
Parameter 1 |
location of the exception |
Parameter 2 |
index name of candidate key |
A row in one or more associated foreign table(s) contains a non-null FK value. You cannot truncate or delete all from a candidate table if any associated foreign key exists having any all non-null data.
