Teradata Database Message 5310 - 17.10 - 5310 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.