Teradata Database Message 3972 - 17.10 - 3972 - 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
This forward referenced table being created conflicts with the constraints defined by table %DBID.%TVMID.
Explanation
The table being created is forward referenced by another table, and its definition is incompatible with the referencing table due to one of the following reasons: (1) the referenced column is not defined. (2) the referenced column type is incompatible with the referencing column. (3) the parent key is not defined as an unique primary or unique secondary index. (4) the parent key was default to a primary key and the parent table does not have one defined.
Generated By
OPT modules.
For Whom
End User.
Notes
None
Remedy
Correct the request and resubmit it.