ALLBASE/SQL Reference Manual (36216-90216)

484 Chapter11
SQL Statements E - R
RENAME COLUMN
RENAME COLUMN
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.
• 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.
Example
RENAME COLUMN Parts.PartNumber to NewPartNum;