Explanation: The EXEC sp_rename command renames the State column in the Customers table to ‘Residential State‘. The resulting table schema reflects this change, displaying the new column name ‘Residential State‘ instead of State, with all data remaining intact.

2. Using ALTER Statement

To rename the column of a database in SQL Server, we can also use the ALTER table command. ALTER is a Data Definition Language(DDL) command that is used to update the schema of tables, views, and indexes in SQL Server. Following is the syntax to rename the column in SQL Server using the ALTER command:

Syntax:

ALTER TABLE table_name RENAME COLUMN old_column_name TO new_column_name

where:

• table_name: is the name of the table containing the column you want to rename.
• old_column_name: is the current name of the column that you want to rename.
• new_column_name: is the desired new name for the column.

Example

To change the column name from CustomerName to User of the above table Customers we will have to run the following query

Query:

ALTER TABLE Customers RENAME COLUMN CustomerName TO Users

Output: