ALTER TABLE TO CURRENT Syntax Elements - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
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 also called 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 or 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 also called a null partition handler. You cannot specify a null partition handler for a join index.