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.

./heLen