How to rename a column in SQL Server 2005

Question

I want to rename the column from a table. I have tried:

Also I do not want to add one more column and assign the data of old column to new and drop old column.

How can I do it ?

Are you not able to open object explorer in Management studio and edit the name of column? — mhn, Sep 24 '14 at 08:46
@mhn i need some script or query, requirenets doesnt allow to use object explorer. — user3817378, Sep 24 '14 at 08:54
@user3817378 so why is it not working for you ? Are you getting an error ? Did you forget to refresh your table ? It works for most other people — t-clausen.dk, Sep 24 '14 at 09:01

score 0 · Answer 1 · answered Sep 24 '14 at 08:48

0

You can use sp_rename as follows :

EXEC sp_RENAME 'table_name.old_name', 'NEWNAME', 'COLUMN'

answered Sep 24 '14 at 08:48

RayofCommand

score 0 · Answer 2 · answered Sep 24 '14 at 08:50

0

Use the Command

EXEC sp_RENAME 'Table_Name.CololdName', 'ColNewName' , 'COLUMN'

it is working perfectly for me

answered Sep 24 '14 at 08:50

Rajesh

score 0 · Accepted Answer · answered Sep 24 '14 at 11:55

0

Its a old version of mssql so does not support above solutions but when i tried like this it works

EXEC sys.sp_rename 'fg.TABLE NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME','COLUMN';

anyway thanks for your efforts

answered Sep 24 '14 at 11:55

user3817378

3 Answers3