Rules and Restrictions | ALTER TABLE | Teradata Vantage - 17.10 - Rules and Restrictions for the Number of Changes Made in One ALTER TABLE Statement - 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)
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.