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.