System Generated Time Series Columns | Teradata Vantage - 17.10 - System Generated Time Series Columns and ALTER TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1208-171K
Language
English (United States)
You cannot specify the system generated time series columns, TD_TIMEBUCKET, TD_TIMECODE, or TD_SEQNO in an ALTER TABLE statement, including:
  • ALTER TABLE table_name ADD column_name
  • ALTER TABLE table_name DROP column_name
  • ALTER TABLE ADD FOREIGN KEY (column_name)
  • ALTER TABLE ADD UNIQUE column_name
  • ALTER TABLE ADD PRIMARY KEY column_name
  • ALTER TABLE RENAME column_name
You cannot add the following column attributes to the system generated time series columns, TD_TIMEBUCKET, TD_TIMECODE, or TD_SEQNO:
  • DEFAULT, DEFAULT NULL, DEFAULT DATE, DEFAULT TIME, or DEFAULT USER
  • NAMED
  • NULL or NOT NULL
  • CASESPECIFIC or NOT CASESPECIFIC
  • CS or NOT CS
  • CHARACTER SET
  • COMPRESS or NO COMPRESS
  • UPPERCASE or UC