CREATE TABLE Syntax Elements (ANSI System-Time Table Form) - Advanced SQL Engine - Teradata Database
ANSI Temporal Table Support
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-27
- dita:mapPath
- kit1592007446534.ditamap
- dita:ditavalPath
- kit1592007446534.ditaval
- dita:id
- B035-1186
- lifecycle
- previous
- Product Category
- Teradata Vantageā¢
- table_name
- The name of the system-time table. May include database qualifier.
- sys_start
- The name of the column that will store the beginning bound of the system-time period.
- GENERATED ALWAYS AS ROW START
- Required attribute for column that defines the beginning bound of system-time period.
- sys_end
- The name of the column that will store the ending bound of the system-time period.
- GENERATED ALWAYS AS ROW END
- Required attribute for column that defines the ending bound of system-time period.
- PERIOD FOR SYSTEM_TIME
- Creates the system-time derived period column.
- SYSTEM VERSIONING
- Required attribute for system-time temporal tables. Must be the last clause in the CREATE TABLE statement.