Skip to content
≡

Administrator

Developer

Tools

External Tools

RENAME TABLE

RENAME TABLE#

Syntax#

rename ::=#

rename

Prerequisites#

The SYS user, the owner of the schema containing the table, and users having the ALTER ANY TABLE system privilege can execute the RENAME TABLE statement.

Description#

This statement is used to change the name of the specified table. Only the table name is altered; none of the data stored therein are changed.

user_name#

This is used to specify the name of the owner of the table to be renamed. If this is omitted, Altibase will assume that the table belongs to the schema of the user connected via the current session.

old_name#

This is used to specify the current name of the table.

new_name#

This is used to specify the new name for the table.

Consideration#

The name of a replication target table cannot be changed.

Example#

<Query> Rename the table employees to emp1

iSQL> RENAME employees TO emp1;
Rename success.

Or 

iSQL> ALTER TABLE employees
  RENAME TO emp1;
Alter success.