SQL Rename Column

In SQL Server, there is a standard stored procedure called SP_RENAME to rename the column name. The syntax of this Rename Column approach is

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

SQL Rename Column Example

In this example, we will rename the column using this SP_RENAME stored procedure. To demonstrate the SQL Server Rename Column, We use the below table.

We use the above-specified SQL Server syntax or stored procedure to rename the YearlyIncome to a new name: Income

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

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

See the changed column

Rename Column using SSMS

If you can access the Management Studio, then right-click on the table, and select the Design from the context menu to change or rename the column.

Selecting the Design option will open the table in design mode. Let me rename the Income column to Annual Income

Click the Close button and select the Yes button from the displayed pop-up window to save the changes you made in the design window.

See the changed column.