August 13, 2008 at 12:39 pm
I'm wondering if there is a quick way to rename database column and table names in Microsoft SQL Server so that the change is applied to all other database objects which depend on that table. Is it possible?
I'm currently doing the renaming process manually by opening an object's dependencies list, then one-by-one opening those which depend on it and alter their code by using a find and replace to update the name of the column/tables accordingly. I'm hoping there's a faster way of doing this
Thanks
icekube12jr
August 13, 2008 at 3:16 pm
RedGate (link at top right of this page) has a product called Refactor that can help with that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 13, 2008 at 10:35 pm
Awesome, thanks a bunch! I'll give it a shot.
icekube12jr
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply