Dany M wrote:

> Rick Debay wrote:
>>> I hope that "practically impossible" doesn't indicate that you're
>> trying to this change while the database is online.
>>
>> Practically impossible means that the field is referenced in dozens of
>> views and stored procedures, which then seem to be referenced
>> themselves. Each of these little fleas have lesser fleas, and so ad
>> infinitum, and each is biting (to butcher Augustus de Morgan).
>>
>
> Happened to me sometimes. What I generally do is extract *all* metadata
> in a script. Search and replace with a nice editor and then create a new
> database, lastly pump the data into the "new" DB and bring it online.
> This is in the (rare) cases when I judge that it's too painful to do it
> "manually".
>

Another "mo" just hit me. There are tools out there called "Database
Comparers". The neat thing with the good ones are that they will
generate a script that take dependecies into account (personally I use
IBExpert but there are others). So instead of the "pumping the data back
in" one can compare with the edited script (or an empty DB generated
from the edited script). Then just run the script. That works a lot of
times.

Regards,

/Dany