|Subject||Re: Commenting whole procedures|
> I am trying to get new versions of our app to detect whether metadataHello Roger,
> changes are required, and to automatically carry them out.
> Commenting out the entire procedure would remove the dependencies
> while table and field changes are being made.
We just use FlameRobin (freeware, see Firebirdsql.org website for
link) to do this. There is a Generate Rebuilt script for different
objects, which takes care of dropping and recreating the dependent
Other tools can accept an original and target database and generate a
script to convert it.