Sometimes we might need to change the table name, and for this purpose, we can use the ALTER TABLE command to rename an existing table.
Syntax
ALTER TABLE Table_Name RENAME TO New_Table_Name
ALTER TABLE Table_Name RENAME COLUMN Old_Name New_Name
Let us see in the real-time example.
For this, we are going to use the employees table.
Changing the table name
ALTER TABLE employees RENAME TO Employee_details
- We can see that using the first syntax, and the table name has been modified into our required one.
Changing the column name
ALTER TABLE Employee_details RENAME COLUMN job_title TO designation
- We can see that the column name has also been modified according to our second syntax.
In this way, we can use this alter table command to rename tables and columns in a database.
- Log in to post comments