HP 3000 Manuals

ALLBASE/SQL Reference Manual

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.

   *   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.

Example 

     RENAME COLUMN Parts.PartNumber to NewPartNum;
[REV END][REV BEG]

MPE/iX 5.5 Documentation