17.10 - Creating ANSI Valid-Time Tables - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

ANSI supports special CREATE TABLE and ALTER TABLE syntax for creating valid-time tables. Creating temporal tables includes:

  • Defining the beginning and ending bound columns for the valid-time period
  • Defining the VALIDTIME derived period column
  • Optional syntax to define primary key, unique, and referential constraints for ANSI valid-time tables.