RENAME COLUMN

The RENAME COLUMN statement defines a new name for an existing column in the DBEnvironment .

Application Programs

  RENAME COLUMN [Owner.]TableName.ColumnName TO NewColumnName

[Owner.]TableName.ColumnName: designates the table column to be renamed.
NewColumnName: is the new column name.

All indexes, columns, default columns, constraints, referential authorization, rules, and user authorities tables dependent on a renamed column will be renamed.
All views dependent on a renamed column will be dropped.
If a column has check constraints, then that column cannot be renamed.

You must have DBA authority to use this statement.

RENAME COLUMN Parts.PartNumber to NewPartNum;

Technical documentation