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.