Teradata Database Message 5311 - 5311 - 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
The specified constraint is inconsistent. Submit ALTER TABLE DROP INCONSISTENT REFERENCES statement instead.
Explanation
The specified referential constraint is inconsistent and cannot be dropped using the ALTER TABLE DROP FOREIGN KEY statement. This can occur after the table is restored. The user must submit an ALTER TABLE DROP INCONSISTENT REFERENCES statement to drop all inconsistent references from the target table.
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.