Subject Re: [firebird-support] create or alter table
Author Richard Mace
On 28/12/05, Lucas Franzen <luc@...> wrote:
> Richard,
> Richard Mace schrieb:
> > Hi,
> >
> > I know that there is a way of using ddl to "create or alter" a table,
> > but it there a similar way of doing the same thing for stored
> > procedures? Or do you just use create procedure and ignore any errors?
> RECREATE PROCEDURE <proecure_name>
> will DROP and CREATE the procedure.
> Will fail if there are depenedencies.
> will create the procedure if it doesn't exits, otherwise will alter it.

Ah, I didn't think you could do that.
I'll give it a go.
Thanks for your help