Rename a Column in SQL Server

Hi makenzi.exc,

In order to rename a column you need to make use of sp_rename.

Syntax

EXEC sp_rename 'table_name.old_name',  'new_name', 'COLUMN'

Example

EXEC sp_rename 'ReminderDays.Description' , 'Name', 'COLUMN'

Note: Changing Column name can break the functionality.

So make sure you have change the column name every where you have used.