Modifying Temporal Tables | ANSI Temporal Table Support | Teradata Vantage - Modifying Temporal 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™

Modifications to temporal tables involve special time-aware handing by the database. Because they are used for different purposes, system-time columns are treated differently than valid-time columns when rows are modified.