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">quote:<hr height="1" noshade id="quote">Originally posted by satya If plenty of rows is included then its better to perform this task from QA rather from EM. Never trust GUI tools … <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center> <hr height="1" noshade id="quote"></blockquote id="quote"> So you recommend against the use of the wonderful Enterprise Manager, satya? [<img src=’/community/emoticons/emotion-3.gif’ alt=’ :eek:

‘ />)] Frank http://www.insidesql.de</a> 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. [^] <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Strange, everybody is going *visual*. Next you’re telling that you know and like the commanyd prompt [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />][<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Frank http://www.insidesql.de</a> 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=’

‘ />] <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by satya Er… command prompt .. yes you guessed it correctly and 100 marks to you Frank…[8D][<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />] <hr height="1" noshade id="quote"></blockquote id="quote"> Marks?!? Currency? satya, welcome to 2004! Since some years I heard some European countries share the same currency. What’s it called… ah yes… thr Euro! [<img src=’/community/emoticons/emotion-3.gif’ alt=’ :eek:

‘ />)] Frank http://www.insidesql.de</a> http://www.familienzirkus.de</a>

]]>