Teradata Database Message 9832 - 9832 - Analytics Database - Teradata Vantage

Message

Specified alter table operation is not supported on a system-versioned table.

Explanation

If a table is a system-versioned table then add or drop column, add DEFAULT clause, add NULL or NOT NULL, change column data type, drop identity column attribute, modify partition WITH DELETE or WITH INSERT, ALTER TABLE TO CURRENT with WITH DELETE or WITH INSERT, revalidate primary index with WITH DELETE or WITH INSERT and add NORMALIZATION option are not supported.

Generated By

RES modules.

For Whom

The end user.

Notes

None

Remedy

Drop system-versioning from the table and then do the required alter operation.