17.10 - ALTER TABLE TO CURRENT Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
table_name
Name of the table whose row partitioning is to be reconciled to a new current date or timestamp value.
join_index_name
Name of the join index whose row partitioning is to be reconciled to a new current date or timestamp value.
WITH INSERT INTO save_table
Table into which to insert any row whose row partition number evaluates to a value outside the valid range.
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.
WITH DELETE
Delete any row whose row partition number evaluates to null or to a value outside the valid range.
The WITH DELETE clause is sometimes referred to as a null partition handler. You cannot specify a null partition handler for a join index.