SQL Rename Column

In this article we will show you, How to Rename Column Name in SQL Server with example. To demonstrate the same, We are going to use the below shown Customers table.

SQL Rename Column Example

In SQL Server, there is a standard stored procedure called SP_RENAME to rename SQL Server column name. In this example we will rename the column using this.

Syntax behind this approach is as shown below:

-- Syntax for SQL Server rename column Name is: 
SP_RENAME '[Table Name].[Old Column Name]', '[New Column Name]', COLUMN'

We are going to use above specified syntax to rename the YearlyIncome to new name: Income

SQL CODE

-- SQL Server Rename Column Name query is: 
USE NewNameDB
GO

SP_RENAME 'Customers.YearlyIncome', 'Income', 'COLUMN'

OUTPUT

From the below screenshot you can see the changed column

SQL Rename Column using SSMS

If you can access the SQL Management Studio then you can use the follow steps to change the column name. Right-click on the Table, and select the Design from the context menu.

Selecting the Design option will open the table in design mode.

Let me rename the Income column to Annual Income

Click the Close button will display the pop-up window. Please select the Yes button to save the changed that you made in the design window.

Now you can see the changed column.