Creating ANSI Bitemporal Tables - Teradata Vantage - Analytics Database

ANSI Temporal Table Support
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jqu1628112571823.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esa1472244798285
lifecycle
latest
Product Category
Teradata Vantage™

Bitemporal tables include a system-time and valid-time dimension. The syntax for creating bitemporal tables combines syntax for creating both a SYSTEM_TIME and valid-time derived period column.