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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
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.