CREATE TABLE Statement (ANSI Bitemporal Table Form) | Teradata Vantage - 17.10 - CREATE TABLE (ANSI Bitemporal Table Form) - 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)

Create a new ANSI bitemporal table.


There is no special temporal syntax for creating bitemporal tables. It simply combines the forms discussed in CREATE TABLE (ANSI System-Time Table Form) and CREATE TABLE (ANSI Valid-Time Table Form). Note that a bitemporal table also combines the rules, restrictions, and usage notes listed for both system-time and valid-time tables..

For example, a bitemporal table cannot be the source table for a CREATE TABLE AS statement, and statistics cannot be collected on the derived period columns of bitemporal tables.

All restrictions for system-time and valid-time columns described in Working With ANSI System-Time Tables and Working With ANSI Valid-Time Tables apply to bitemporal tables.