17.00 - Time Series PTI Table Creation - Teradata Database

Teradata Vantage™ - Time Series Tables and Operations

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1208-170K
This section covers information relevant to time series tables (tables having a primary time index). Most syntax diagrams show only the portion of syntax that is specifically relevant to time series PTI tables, which is a subset of the full SQL statement syntax. Unless otherwise noted, most of the existing rules and options that apply to conventional non-PTI tables also apply to time series tables. For information on SQL syntax for conventional tables, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144, Teradata Vantage™ - SQL Data Manipulation Language, B035-1146, and Teradata Vantage™ - SQL Data Control Language, B035-1149.