Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
potchakri
Starting Member
10 Posts |
 Posted - 2007-08-08 : 09:32:11
|
| Hi all,I need to rename the Columns of a table in SQL Server 2005.The table is consisting of nearly 200 columns and the requirement is that every column needs to be appended with a name that would be given by me.Example: Let the name of the table be "Applicationdata"let it contain columns say NameDOBGenderPlaceQualificationnow I need to add a code say "Appl" before every column so that after the code is run, the column names sholud be changed asAppl_NameAppl_DOBAppl_GenderAppl_PlaceAppl_Qualification.Do we have any procedure like that, if yes, please post it. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
Renaming Columns