Rename column SQL Server 2008

Question

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL.

ALTER TABLE table_name RENAME COLUMN previous_name to new_name;

This statement doesn't work.

Answer 1

Use sp_rename

EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN'

See: SQL SERVER – How to Rename a Column Name or Table Name

Documentation: sp_rename (Transact-SQL)

For your case it would be:

EXEC sp_RENAME 'table_name.previous_name', 'new_name', 'COLUMN'

Don't forget to use single quotes to enclose your values.