MS SQL Server Rename Column

The RazorSQL alter table tool includes a Rename Column option for renaming an MS SQL Server database table column. The rename column option allows the user to type in a new name for the column being renamed. The tool then generates and can execute the SQL to rename the column on the table.

Listed below is an example of the SQL generated by the MS SQL Server Rename Column function:

exec sp_rename @objname = 'test.dbo.Employee.ssn', @newname = 'ssn_new', @objtype = 'COLUMN'

Below is a screen shot of the rename column function of the MS SQL Server alter table tool.

MS SQL Server Rename Column