SQL Rename Column

SQL Rename Column 6

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 We will alter the name using this SP_RENAME stored procedure in this example. To demonstrate the Rename Column, We use the below … Read more