15.00 - 9329 A temporal column cannot be dropped. The table has %VSTR. - 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)

9329 A temporal column cannot be dropped. The table has %VSTR.

Explanation:

A temporal table has constraints (CHECK, UNIQUE, PRIMARY KEY or RI) or join index or trigger defined. The existing constraints or join index or triggers are associated with the temporal time dimension and hence the temporal column cannot be dropped.

Generated By:

OPD modules.

For Whom:

End User.

Remedy:

Drop the constraints and join indexes and triggers before dropping a temporal column.