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'