Subject Re: DDL Question
Author Adam
--- In firebird-support@yahoogroups.com, "Anderson Farias"
<peixedragao@...> wrote:
>
> BTW,
>
> I never take users off when creating new objects (including alter
table add
> field). Are there any potential problems on that?
>
> And how about altering stored procs ??
>

I am not willing to make a blanket statement because I believe there
are slight differences in behaviour between FB 1.5 and FB 2 when it
comes to caching metadata.

Having said that, you may have trouble with 'object in use' style
errors and end up with some of your DDL failing. For this reason
alone, we never perform DDL changes on an active database.

Adam