Change column name in SQL Server 2014

Question

How to change the column name in SQL Server 2014 using query?

Answer 1

For this you can use this query

USE DATABASE;  
GO  
EXEC sp_rename 'TABLE.COLUMN_NAME', 'COLUMN_NEW_NAME', 'COLUMN';  
GO

You will have to replace DATABASE,TABLE,COLUMN_NAME and COLUMN_NEW_NAME with your data