Search code snippets, questions, articles...

Rename table SQL command

RENAME old_table_name TO new_table_name;
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

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 below SQL query for that.

RENAME Employee TO Employee_Data
Was this helpful?