Existing name for the table.
- database_name
- user_name
- Optional name of the containing database or user for the table to be renamed if other than the current database or user.
Example
The following request renames the emp table as employee.
RENAME TABLE emp TO employee;