System Generated Time Series Columns | Teradata Vantage - 17.00 - System Generated Time Series Columns and ALTER TABLE - 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
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