--- In firebird-support@yahoogroups.com, "dosinovsky"
<dosinovsky@y...> wrote:

> Hi!
>
> I need to alter view from my program, but I have a problem: there are
> stored procedures that uses that view. It would not let me commit
> transaction where I drop the view, even if I recreate it in the same
> transaction. What should I do? Maybe in Firebird there is something
> like "create or replace view"?
>
> TIA.
>
> Regards,
> Dmitry

Gotcha!

Sorry Dmitry, there is no DDL in Firebird to modify a view, you are
going to have to alter every stored procedure that relies on that
view, and drop any view that relies on that view, then alter any
stored procedure that in turn relies on that second view etc etc.

Yes I have had a 700 line .sql script to add one line to a view.
Apparently there is some voodoo you can do in the system tables to
make the change, but I have no idea how that works.

Sorry it is not better news, hopefully it will find its way into a
development list for FB 3 or 2.5 or something, but for now, don't nest
views.

Adam