CREATE TABLE Statement (ANSI Bitemporal Table Form) | Teradata Vantage - CREATE TABLE (ANSI Bitemporal Table Form) - Analytics Database - Teradata Vantage

Create a new ANSI bitemporal table.

Syntax

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.