You have a table and you want to change the name of a column or want to change the name of the table.

Solution –
Change the name of a column In SQL-
To change the name of a column you can use the ALTER TABLE statement. Let’s change the name of the salary column to christmas_spending in the actors table.
ALTER TABLE actors
RENAME COLUMN salary TO christmas_spending

Change the name of a Table in SQL –
We can also change the name of a table using the ALTER TABLE statement.
Let’s change the name of the actors table to actors_info
ALTER TABLE actors
RENAME TO actors_info

One thought