ANSI Temporal Tables - Analytics Database - Teradata Vantage

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
eud1628112402879.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
fif1472244754791
lifecycle
latest
Product Category
Teradata Vantage™

This section describes the major differences between Teradata’s proprietary implementation of temporal tables and syntax, which is described in this document, and Teradata’s implementation of ANSI/ISO compliant temporal tables, which is described in Teradata Vantage™ - ANSI Temporal Table Support, B035-1186. It also describes three methods that can be used to convert transaction-time tables into ANSI-compliant system-versioned system-time tables.