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

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
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.