Rename a Column in SQL Sever

To rename a column follow the below mentioned steps:

1. In Object Explorer, connect to an instance of Database Engine.

2. On the Standard bar, click New Query.

3. The following example renames the column name in the table Publishers.name to PublisherName. Copy and paste the following example into the query window and click Execute.

EXEC sp_rename 'Publishers.name', 'PublisherName', 'COLUMN'