Teradata Database Message 5739 - 5739 - Analytics Database - Teradata Vantage

Message

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

Explanation

A partitioning column cannot be dropped by an ALTER TABLE statement.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

If the column needs to be dropped, 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 drop the column.