> > and IBExpert too.
> > but not sure if all these separate actions could be auto aggregated
> in the
> > same way that a dependency line would be.
> > Alan
> >
> Agree about IBExpert, not sure I understand about actions being auto
> aggregated - do you mean upsizing the FKs in the middle? -> Max
>
>

I mean that when you alter an SP where other SPs are dependent upon it,
IBExpert and others (auto)generate this dependency chain script which is
aggregated in correct sequence of alter with no body then alter with full
body including changes etc.

I don't think this same set of commands can be generated for FK/PK changes.
If field dropping is required then re-population of data is required also -
seems to me to be something a manual approach would provide more comfort on.

That said, if you are upsizing a field, it's likely that just upsizing all
related fields (dependent on it) would be enough. Followed by a backup
restore cycle and perhaps all this done on a test copy first, until the
script is all sorted.
Alan