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

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