Loading

Change Column Name in Sqlserver

This Blog will give you information about how to change column name in Sqlserver using query.

Ankit Nandekar

May 5, 20111 min read3.9k0025Blog

Comments

Join the conversation! Your thoughts help the community grow.

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'

Written byAnkit Nandekar61 pieces published on C# Corner

View profile