WITH INSERT - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.