17.05 - WITH INSERT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)

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
save_table and the table being altered must be different tables. Also, 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 as long as the tables referenced in the request are all row-level security-protected and they are all be 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.