Teradata Database Message 2726 - 2726 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
Referential constraint violation: cannot delete/update the Parent Key value.
Explanation
At least one of the Parent Key (i.e. referenced columns) values being deleted or updated is referenced by some Foreign Key values. By definition, the Parent Key value cannot be deleted or updated if there exists a Foreign Key value which is referencing it. Note, this is typically caused by an SQL Delete or Update statement on a referenced table.
Generated By
SutCKPRw.
For Whom
End user.
Notes
None
Remedy
Delete the corresponding Foreign Key value from the Child table (i.e. referencing table) first and then resubmit the request.