17.10 - ALTER TABLE Syntax (ANSI Valid-Time Table Form) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)

Use the following ALTER TABLE syntax to create a valid-time table by adding a valid-time derived period column:

ALTER TABLE table_name
  ADD PERIOD FOR valid_time_period ( valid_start, valid_end ) [AS] VALIDTIME [;]

Use the following syntax to drop a valid-time derived period column:

ALTER TABLE table_name
  DROP valid_time_period [ WITHOUT DELETE ] [;]