ram-912425
Old Hand
Points: 317
More actions
January 20, 2009 at 1:31 am
#196301
hi friends,
this is ram.currently i am working on sql server2005.
in sql server2005 how can i change the column name.if any body knows plz help me.
thanks in advance.
Adi Cohn-120898
SSC-Dedicated
Points: 33944
January 20, 2009 at 1:39 am
#929536
You can do it with sp_rename. Just make sure that the third parameter is column. You can check for more details in BOL.
Adi
--------------------------------------------------------------To know how to ask questions and increase the chances of getting asnwers:http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
steveb.
SSC-Forever
Points: 46733
January 20, 2009 at 2:47 am
#929556
Right Click on the column in SSMS and click rename..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply