15.00 - ALTER TABLE (Basic Table Parameters) - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

ALTER TABLE (Basic Table Parameters)

ALTER TABLE and Table Version Numbers

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
  • If the ARC utility encounters such a structural table change during a rollforward or rollback operation, then that operation is stopped and an error message is returned in the output listing.