15.00 - 9321 A temporal column cannot be added to a table which has a referential integrity constraint. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

9321 A temporal column cannot be added to a table which has a referential integrity constraint.

Explanation:

The table being altered to add ValidTime and/or TransactionTime column/s has RI defined on it. A temporal column cannot be added to table with RI.

Generated By:

RES Modules

For Whom:

End User.

Remedy:

Drop the RI on the table being altered and then alter it to add ValidTime or TransactionTime columns.