15.10 - WITH INSERT - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Insert into save_table any row for which a new partitioning level evaluates to a value outside the valid range of 1 through the number of partitions defined for that level. After it inserts the non-valid row, Teradata Database deletes it from the table.

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.

INTO
Optional keyword.
save_table
save_table and the table being altered must be different tables, and save_table must have the same number of columns (with matching data types) as the table being modified.