Rename table SQL command

In SQL, the RENAME TABLE command is used to change the name of a table. This can be useful if you want to change the name of a table to something more descriptive, or if you need to change the name of a table to conform to a naming convention.

RENAME old_table_name TO new_table_name;

# Example 1: Rename the Employee table to Employee_Data

RENAME query in SQL is used for changing the name of the table. For example, if a table named "Employee" exists in the database and you want to rename or change its name to "Employee_Data", you can run the below SQL query for that.

RENAME Employee TO Employee_Data

Was this helpful?