|
|
|
RENAME
Description
Renames the specified table name, view name or synonym to the new name specified.
Syntax
RENAME [owner_name.] oldname TO [owner_name.] newname ;
Arguments
[owner_name.]
Optional owner-name qualifier for the name. If the owner name is not the same as that of the current user, the current user must have the DBA privilege.
If specified, the owner name must be the same for oldname and newname. In other words, you cannot change the owner of a table, view, or synonym with RENAME.
oldname
Current name of the table, view, or synonym.
newname
New name for the table, view, or synonym.
Example
RENAME sitem TO supplier_item ;
Authorization
The user executing this statement must have any of the following privileges:
SQL Compliance |
Extension |
Environment |
Embedded SQL, interactive SQL, ODBC applications |
Related Statements |
CREATE TABLE, CREATE VIEW, CREATE SYNONYM |
