--- In firebird-support@yahoogroups.com, Lucas Franzen <luc@r...>
wrote:

> > I read in the Release Notes of FB version 1.5 the new commands

RECREATE

> > PROCEDURE and CREATE OR ALTER PROCEDURE. What is the difference

with the

> > already existing command ALTER PROCEDURE?
> >
> > Seems to do the same thing regarding to exitsing procedures.
>
> It will do an ALTER PROCEDURE if the procedure exits,
> it will do a CREATE PROCEDURE if it doesn't.
>
> I think the docs are pretty clear about that.
>
>

Luc, CREATE OR ALTER - yes. RECREATE will drop existing procedure
if it exists and create new. Will fail if there are dependencies and
have more chances to fail on "object in use" IMO. Have'nt at hand last
version of RN so can't surely say is it pretty clear or not ;)

Best regards,
Alexander.