"Cannot delete/truncate CK %2 because of RI violation - FK has non-nulls. %1"
| Item |
Description |
|
SQLCode
|
-1009150L
|
|
Constant
|
EMSG_RI_VIOLATION_FKNOTNULL
|
|
SQLState
|
QSB46
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
20190
|
|
Severity Code
|
14
|
|
Parameter 1
|
location of exception
|
|
Parameter 2
|
index name of candidate key
|
Probable cause
No additional information available. Cannot truncate or delete all from candidate table if there exists any associated foreign key which has any all non-null data.