Rename Column | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Rename Column

I have a table with plenty of rows. Now i need to rename a column (eg: fieldone is the oldname, i want to change that to fieldtwo without losing the existing rows.), Is this possible?
Take a look at sp_rename in BOL
Frank
http://www.insidesql.de
http://www.familienzirkus.de
Also you can do it using EM. Of course take care about application.
Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
If plenty of rows is included then its better to perform this task from QA rather from EM.
Never trust GUI tools … Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />If plenty of rows is included then its better to perform this task from QA rather from EM.<br />Never trust GUI tools …<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of knowledge sharing.</font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br />So you recommend against the use of the wonderful Enterprise Manager, satya? [<img src=’/community/emoticons/emotion-3.gif’ alt=’:eek:‘ />)]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
To be precise for such admin. activities I strongly agree and encourage to use QA rather than *&^*wonderful EM*&^*[}<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />] which is meant to be flaky and utterly disappointing tool in such cases.<br />[^]<br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of knowledge sharing.</font id="size1"></font id="teal"></center>
[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />] Strange, everybody is going *visual*. <br /><br />Next you’re telling that you know and like the commanyd prompt [<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br /><br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
Hey I am a die hard fan of command prompt and use the OSQL utility so much… Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
Er… command prompt .. yes you guessed it correctly and 100 marks to you Frank…[8D][<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />]<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of knowledge sharing.</font id="size1"></font id="teal"></center>
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Er… command prompt .. yes you guessed it correctly and 100 marks to you Frank…[8D][<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />]<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br />Marks?!? Currency?<br />satya, welcome to 2004! Since some years I heard some European countries share the same currency. What’s it called… ah yes… thr Euro! <br /><br />[<img src=’/community/emoticons/emotion-3.gif’ alt=’:eek:‘ />)]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
]]>