Sometimes, it may be necessary to rename a table. There is no standard way to rename a table, and the implementation varies by RDBMS. Below we discuss how we can rename a table in MySQL, Oracle, and SQL Server.
MySQL
In MySQL, we can rename a table using one of the following methods:
Method 1
RENAME OLD_TABLE_NAME TO NEW_TABLE_NAME
Method 2
ALTER TABLE OLD_TABLE_NAME
RENAME TO NEW_TABLE_NAME