CREATE 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_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.
precision
The precision of the timestamp value. The default is 6.
valid_time_period
The name of the valid-time derived period column.
VALIDTIME
Required to create valid-time tables in the database.
This clause allows SELECT statements on valid-time tables to use special temporal qualifiers (AS OF, BETWEEN ... AND, FROM TO, CONTAINED IN), which ANSI does not support on valid-time tables. For more information see Querying ANSI Valid-Time Tables.
[AS] VALIDTIME is a Teradata extension to ANSI.