System-Time Modifications - 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ā„¢

Temporal modifications to system-time columns are straightforward and entirely automatic. They are not influenced by the nature of the modification.

  • When a row is deleted from a system-time table, the row is not physically deleted from the table. The end of the system-time period of the row is set to the time of the deletion, and the row becomes a closed row. It no longer participates in most SQL operations on the table, but remains in the table as a historical record of what existed in the past.
  • When a row is modified in a system-time table, the end of the system-time period of the row is set to the time of the modification, closing the row, and a copy of the row with the modified data is inserted into the table. The system-time period of the new row begins at the time of the modification, and ends at UNTIL_CLOSED. The new row is active in the database and can participate in SQL operations.

For more information on modifying ANSI system-time tables, see Modifying Rows in ANSI System-Time Tables.