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.