17.10 - ALTER TABLE and Table Version Numbers - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Any change to the structure of a table or join index increments its version number.

You cannot perform any of the following actions over a DDL request that alters table structure.

  • Cluster restore
  • Single AMP restore
  • Rollforward or rollback of a permanent journal