beyondrelational.com



Forums » SQL Server Forums » Transact SQL » Rename a column

Rename a column

rated by 0 users
Answered (Verified) This post has 2 verified answers | 3 Replies | 2 Followers

Top 100 Contributor
6 Posts
Points 120
Saeed posted on 01-28-2010 3:38 PM

can somebody please help me in renaming a column.. i just want a script to rename a column i just wan to rename a column

copy_prev  to copy_current

So can anybody help me in this.

  • | Post Points: 50

Answered (Verified) Verified Answer

Top 150 Contributor
5 Posts
Points 60
Reply
Answered (Verified) visakhm replied on 01-29-2010 2:50 AM
Verified by Jacob Sebastian

use sp_rename system stored proc

 

http://msdn.microsoft.com/en-us/library/ms188351.aspx

  • | Post Points: 25
Top 10 Contributor
Male
92 Posts
Points 785
Reply
Answered (Verified) Ashish Gilhotra replied on 01-29-2010 5:45 AM
Verified by Jacob Sebastian
You can use EXEC sp_rename 'copy_prev', 'copy_current', 'COLUMN' and if you want to rename any table just do it like this EXEC sp_rename 'table_old' , 'table_new'
  • | Post Points: 25

All Replies

Top 150 Contributor
5 Posts
Points 60
Reply
Answered (Verified) visakhm replied on 01-29-2010 2:50 AM
Verified by Jacob Sebastian

use sp_rename system stored proc

 

http://msdn.microsoft.com/en-us/library/ms188351.aspx

  • | Post Points: 25
Top 10 Contributor
129 Posts
Points 1,245
Reply
Madhivanan replied on 01-29-2010 3:11 AM

Also make sure that you need to change the queries,procedures,etc to reflect this if the column is referred there

  • | Post Points: 5
Top 10 Contributor
Male
92 Posts
Points 785
Reply
Answered (Verified) Ashish Gilhotra replied on 01-29-2010 5:45 AM
Verified by Jacob Sebastian
You can use EXEC sp_rename 'copy_prev', 'copy_current', 'COLUMN' and if you want to rename any table just do it like this EXEC sp_rename 'table_old' , 'table_new'
  • | Post Points: 25
Page 1 of 1 (4 items) | RSS
Copyright © Beyondrelational.com