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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.