Teradata Database Message 5310 - 5310 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
Cannot validate referential constraint containing inconsistent information.
Explanation
The referential constraint specified in the host REVALIDATE REFERENCES statement cannot be validated. This can occur if a restored table references a table which has already been dropped. The error message is returned to the host utility such that it can display a message to inform the user to take appropriate actions.
Generated By
OPT modules.
For Whom
Host Utility.
Notes
None
Remedy
The user must submit statement ALTER TABLE <tablename> DROP INCONSISTENT REFERENCES to remove inconsistent referential constraints.