--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 10:39 AM 25/02/2009, you wrote:
> >> But in this case you could also use:
> >>
> >> CREATE OR ALTER PROCEDURE
> >> and
> >> CREATE OR ALTER TRIGGER
> >
> >Thank you Adam and Helen:
> >
> > I'd rather do neither, if the procedure or trigger already exist.
> >Is there something analogous to RDB$RELATIONS RDB$RELATION_NAME

(for tables) that can be tested for the existence of these items?

>
> RDB$PROCEDURES.RDB$PROCEDURE_NAME
>
> RDB$TRIGGERS.RDB$TRIGGER_NAME
>
> Refer to Appendix IX of The Book.

Thanks Helen:

Larry