> > Adam
> If you use a tool like IBExpert, all this is done for you. IBExpert will
> create a script to drop all dependent objects, then create the new

object,

> then re-create all these dependent objects again. It's all done in

just one

> button click.
> Alan

We didn't have it back then. We were trialing IBAdmin and DBWorkbench
to see what worked best for us. Funding to buy it has been passed
(finally) by management, so hopefully I can use it soon. Forgetting
the extra effort on my part, I am sure you agree it is a lot of effort
for firebird itself, the final script was getting close to 1000 lines
for what should have been a 20 line SQL script.

I would still warning newcomers that there is no native firebird way
of altering a view, and so nested views are harder to maintain. As
Alan points out, there are tools that offer a work around by
automating the new script.

Adam