ALLBASE/SQL Reference Manual (36216-90216)

Chapter 11 485
SQL Statements E - R
RENAME TABLE
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.
• 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;