HP 3000 Manuals

ALLBASE/SQL Reference Manual

RENAME TABLE 

The RENAME TABLE statement defines a new name for an existing table in
the DBEnvironment.

Scope 

Application Programs

SQL Syntax 

RENAME TABLE [Owner.]TableName TO NewTableName 

Parameters 

[Owner.]TableName       designates the table to be renamed.

NewTableName            is the new table name.

Description 

   *   All indexes, columns, default columns, constraints, referential
       authorization, rules, and user authorities tables dependent on a
       renamed table will be renamed.

   *   RENAME statement is not allowed for IMAGE/SQL tables.

   *   When using RENAME command, data and grants made for tables are
       carried forward for the new name.  No unload, load data, or
       recreating index is necessary.

   *   All views dependent on a renamed table will be dropped.

   *   If a table has check constraints, then that table cannot be
       renamed.

Authorization 

You must have DBA authority to use this statement.

Example 

     RENAME TABLE PurchDB.Parts to NewParts;
[REV END]

MPE/iX 5.5 Documentation