Sql server rename a column

Question

How to rename a column "foo" into "bar" in a table "mytable"? I tried:

Alter table mytable
Alter column foo bar;
Alter table mytable  change foo bar;
Alter table mytable rename column foo to bar;

But it didn't work.

Answer 1

Just a reminder. Renaming columns is dangerous, because it might break scripts.

sp_rename 'MYDB.FOO', 'BAR', 'COLUMN'; 

Answer 2

If you are using SSMS, you can just right click and press "Rename"...