How to change column name in SQL?

Question

Can anyone tell me how to change the column name in SQL?

Answer 1

In MySQL, here is the syntax to rename the column:

ALTER TABLE table_name

change column1 column2 data type;

In Oracle, here is the syntax to rename the column:

ALTER TABLE table_name

RENAME COLUMN column1 to column2;

In MS SQL, we cannot use Alter table statement to change the column name. We use sp_rename to change the column name and here is the syntax to rename the column:

sp_rename ‘previous_table_name’, ‘new_table_name’;

If you want to learn SQL, you can enroll for this SQL course program by Intellipaat.