Teradata Database Message 5740 - 5740 - Analytics Database - Teradata Vantage

Message

Column %VSTR is a partitioning column and cannot be altered.

Explanation

A partitioning column cannot be modified by an ALTER TABLE statement unless the modification does not change the data type, nullability, or name of the column.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

If the column needs to be altered, alter the partitioning expression such that the column is not a partitioning column or remove partitioning from the primary index. Then resubmit the ALTER TABLE to alter the column. If desired, the partitioning may then be altered to include the column.