RENAME:
This command is used to
change the table name from old table name to new table name.
Guidelines for RENAME
Columns:
- The RENAME command can be used
to change the name of TABLE, VIEW, SEQUENCE, SYNONYM.
- To RENAME the OBJECT we must be
the OWNER of the OBJECT.
Syntax:
RENAME <old table
name> to <new table name>;
EX:
SQL>rename emp to employee;
SQL>rename employee to emp;
No comments:
Post a Comment