Changing a column name in SQL Server 2008

Question

How to change a predefined column name to a new name.

eg: Column name is "Accounts" I want to change it to "A/c" 

alter table emp change Accounts .... [What's Next]

Answer 1

You need to use the sp_rename command or use Management Studio to do it visually - make sure you do it in a quiet period and make sure that it was done in pre-production first with testing!

By the way, I would stay away from A / C - the slash sign is a separation of special meaning.

The documentation for sp_rename is here, example B is most suitable. http://msdn.microsoft.com/en-us/library/ms188351.aspx

Answer 2

script to rename any column:

 sp_RENAME 'TableName.[OldColumnName]' , 'NewColumnName', 'COLUMN' 

(Note that you are not using screens in the second argument, surprisingly.)

script to rename any object (table, sp, etc.):

 sp_RENAME '[OldTableName]' , 'NewTableName' 

see here for more information

Answer 3

You can use sp_rename as:

 sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' 

as your code looks like this:

 sp_RENAME 'table.Accounts','Acc','COLUMN' 

Answer 4

Here is the code for sp_rename

 sp_RENAME 'emp.Accounts' , 'Acc' 

I used something like this and worked

Answer 5

 sp_rename 'table_name.accounts', 'A/C', 'column' 

This request will solve your problem.

Answer 6

The command to rename any column name:

 sp_RENAME 'TableName.[OldColumnName]' , 'NewColumnName' 

It works without using the third column argument at the end.