Rename a Column in SQL Sever

Sometimes it happens that we misspell the column name or wish to rename the column. We can do so by following the steps in this post.

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'