In SQL Server 2005, 2008, 2012 to rename a column in a table we can call an SP sp_RENAME as below :
Alternately, open the table in Object Explorer and then right click on the desired column and select RENAME. Give a new column name here.
Reference: Govind Badkur(http://sqlserver20.blogspot.com)
EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'
Alternately, open the table in Object Explorer and then right click on the desired column and select RENAME. Give a new column name here.
Reference: Govind Badkur(http://sqlserver20.blogspot.com)
