ALTER TABLE Syntax Elements (Revalidation) - Teradata VantageCloud Lake

REVALIDATE

Update the data dictionary as needed. This also regenerates the table headers for a partitioned table.

You can optionally verify row partitioning and correct any errors that are found during the verification process for a row-partitioned table by specifying either the WITH DELETE or WITH INSERT INTO save_table options.

WITH DELETE

Delete any row for which a partitioning expression evaluates to a value outside the valid range of 1 through the number of partitions defined for that level.

This option is valid only for row-partitioned tables. You cannot specify the WITH clause for join indexes.

WITH INSERT

Insert into save_table any row for which a partitioning expression evaluates to a value outside the valid range of 1 through the number of partitions defined for that level. The non-valid row is inserted into the save_table and deleted from the source table.

This option is valid only for row-partitioned tables. You cannot specify the WITH clause for join indexes.

INTO

Optional keyword to precede save table specification.

save_table

The save_table and the table being altered must be different tables.

The save_table must have the same number of columns as the table being modified and the column data types must match.

You can use this option with row-level security-protected tables if the tables referenced in the request are row-level security-protected and defined with the same row-level security constraints. If you do not specify the constraint values to be inserted into the target table, Vantage takes the constraint values for the target table from the source table.