Monday 6 January 2014

How to rename database table column with new name?

You need to use the sp_rename command, or use Management Studio to do it visually. Now, to change the Column Name from "Old_Name" to "New_NameChange" we can use command:
sp_RENAME 'Table_Name.[Old_Name]', '[New_NameChange]' , 'COLUMN'