17.00 - WITH INSERT INTO save_table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Insert any row whose row partition number evaluates to a value outside the valid range into the table specified by save_table.

The keyword INTO is optional.

The WITH INSERT INTO save_table clause is sometimes referred to as a null partition handler. You cannot specify a null partition handler for a join index.

The save_table and the table being altered must be different tables with different names or they must be in different databases.