Rename Column SQL Tutorial

Rename Column Syntax:

EXEC sp_rename 'Table.Old_Column', 'New_Column', 'COLUMN'

Employee table:

Column nameData_type
idint
namevarchar(250)
dep_idint
addressvarchar(400)

Rename Column Example:

EXEC sp_rename 'employee.address', 'new_address', 'COLUMN' ;

Rename Column Result:

Column nameData_type
idint
namevarchar(250)
dep_idint
new_addressvarchar(400)