How can I rename my column in a SQL table?

Question

How can I rename a column via alter table in MS SQL 2005?

For example:

alter table tablename rename "old col name" to "new col name"

Answer 1

sp_rename 'TableName.ColumnName', 'NewColumnName', 'COLUMN'