Change Column Name in Sqlserver

The script for renaming any column :
sp_RENAME 'TableName.[oldcolumnname]' , '[Newcolumnname]', 'COLUMN'

For example if my table name is class and having column fees and i want to change column name fees to NewFees then the script will be like

sp_RENAME 'dbo.class.fees', 'NewFees' , 'COLUMN'
Ebook Download
View all
Learn
View all