Existing name for the table.
- Optional name of the containing database or user for the table to be renamed if other than the current database or user.
- You cannot use this statement to change the database or user qualifier for the table.
The following request renames the emp table as employee.
RENAME TABLE emp TO employee;