How to rename table column

How to rename table column using T-SQL

 

Again very simple just use system SP

SP_RENAME

 

 

Make sure that you are in same DB whose table’s column you want to change

EXEC sp_rename 'Schema.Table.ColumnName', 'NewName', 'COLUMN';