ALTER TABLE Syntax Elements (ANSI Valid-Time Table Form) - Analytics Database - Teradata Vantage

ANSI Temporal Table Support
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
jqu1628112571823.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esa1472244798285
lifecycle
latest
Product Category
Teradata Vantage™
table_name
The name of the valid-time table. May include database qualifier.
valid_time_period
The name of the valid-time derived period column.
valid_start
The name of the column that will store the beginning bound of the valid-time period.
valid_end
The name of the column that will store the ending bound of the valid-time period.
[AS] VALIDTIME
Required to create valid-time tables in Vantage.
The [AS] VALIDTIME clause allows SELECT statements on valid-time tables to use special temporal qualifiers (AS OF, BETWEEN, FROM TO, CONTAINED IN), which ANSI does not support on valid-time tables. For more information see Valid-Time Modifications.
[AS] VALIDTIME is a Teradata extension to ANSI.
WITHOUT DELETE
Prevents automatic deletion of history and future rows when the valid-time derived period column is dropped from a table.
WITHOUT DELETE is a Teradata extension to ANSI.