17.10 - Renaming Table Columns - 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)

You can rename table columns except when the:

  • new_column_name matches any existing column name in the target table.
  • Column is an index field.
  • Column is part of any type of referential constraint.
  • Column is a partitioning column for a partitioned primary index.
  • Column is referenced in the UPDATE OF clause of a trigger.