15.00 - Renaming Table Columns - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Renaming Table Columns

You can rename table columns within certain restrictions.

Renaming is rejected when any of the following is true.

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