In SQL Server, there is a standard stored procedure called SP_RENAME to rename the column name. The syntax of this approach is
SP_RENAME '[Table Name].[Old Column Name]', '[New Column Name]', COLUMN'
SQL Rename Column Example
In this example, we will alter the name using this SP_RENAME stored procedure. To demonstrate the Rename Column, We use the below table.
We use the above-specified Server syntax or stored procedure to rename the YearlyIncome to a new name: Income
USE NewNameDB GO SP_RENAME 'Customers.YearlyIncome', 'Income', 'COLUMN'
See the change
Change Column Name using Management Studio
If you can access the Management Studio, then right-click on the table, and select the Design from the context menu to change the col name.
Selecting the Design option will open the SQL table in design mode to rename column. Let me change the Income 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 name.
