Query to rename column name in Sql Server 2008

Syntax:

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

Query Example:

  EXEC sp_RENAME 'ExceptionLog.exceptionLog', 'LogMessage', 'COLUMN'


Enjoyyy....