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.
>
> CREATE OR ALTER PROCEDURE <proecure_name>
> 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

Richard