SQL Rename Command

SQL RENAME Command

The SQL RENAME command is used to change the name of the table or a database object.

If you change the object's name any reference to the old name will be affected.

You have to manually change the old name to the new name in every reference.

Syntax to RENAME a table:
RENAME old_table_name To new_table_name;
For Example:
To change the name of the table employee to my_employee, the query would be like
RENAME employee TO my_emloyee;