The RENAME COLUMN statement defines a new name for an existing column in the DBEnvironment.
Scope
Application Programs
SQL Syntax
RENAME COLUMN [Owner.] TableName.ColumnName TO NewColumnName
Parameters
[Owner.]TableName.ColumnName
designates the table column to be renamed.
NewColumnName
is the new column name.
Description
All indexes, columns, default columns,
constraints, referential authorization, rules, and user authorities tables
dependent on a renamed column will be renamed.
RENAME statement is not allowed for IMAGE/SQL tables.
All views dependent on a renamed column will be dropped.
If a column has check constraints, then that column cannot be renamed.
Authorization
You must have DBA authority to use this statement.