PenWin wrote:

> About a hundred depending procedures, which have their own dependencies
> and so on...

Only first level of dependencies is important for procedures because you
can alter them to have an empty body without dropping.

Recursive dependencies are important for views and computed columns only.

In FlameRobin, you can select the "Generate rebuild script" option on
table's properties page and it will create all the ALTER PROCEDURE,
ALTER TRIGGER, etc. statements for all dependent objects. It also does
the same for views (recursively).

I'm sure other admin. tools you might be using have a similar feature.

HTH



--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================