--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:

>
> > How do I test for the existance of
> > the procedure or trigger name?
>
> We keep our patches sequential and have a table that stores the
> patches that have been applied to the database.
>
> 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?

As always, I appreciate your assistance.

Larry