>
> 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
>

That's a point!

Is the backup file in a pseudo readable form? What is a backup was taken, the
required fields changed in the backup file itself, then restored and tested?

It then handles the re-construction and re-creation of all constraints,
triggers, procedures, etc...

...jsut a thought.

N.