Modifying Rows in ANSI System-Time Tables - Advanced SQL Engine - Teradata Database

ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ngt1556732962433.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1186
lifecycle
previous
Product Category
Teradata Vantage™

When modifications are made to rows in system-versioned system-time tables, Teradata Database provides automatic handling of the system-time period as needed to maintain the information in a time-aware fashion.

DELETE and UPDATE modifications to system-time tables leave permanent records of the changes in the database. Deleted rows are “closed” in system time by having the end of their system-time period set to the time of the deletion. Modifications to rows close the old row in system time, and automatically create new rows to reflect the new information with system-time periods that begin at the time of the modification.

Closed rows persist in system-time tables until they are explicitly removed and physically deleted from the table. This can only happen if the system versioning is explicitly dropped from the table, whereupon all closed rows are automatically deleted.

The mechanism of new rows being automatically generated by Teradata Database for modifications to temporal tables is described in more detail in Modifying Temporal Tables.