16.20 - Rules and Restrictions for the Number of Changes Made in One ALTER TABLE Statement - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

The rules for number of changes that can be made within a single ALTER TABLE statement are as follows.

  • Only one change can be made per column per ALTER TABLE statement.
  • Only one CHECK alteration is permitted per ALTER TABLE statement, and you cannot mix CHECK and non-CHECK alterations on the same table for the same ALTER TABLE statement.