15.00 - 9175 Table %VSTR must be empty to decrease precision or scale. - 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)

9175 Table %VSTR must be empty to decrease precision or scale.

Explanation:

Precision and scale for a number column cannot be decreased by a ALTER TABLE statement when the table is non-empty.

Generated By:

OPD modules.

For Whom:

End User.

Remedy:

If the precision/scale needs to be decreased for a number column, delete all the rows in the table.