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 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 … Read more