Subject Re: [firebird-support] Values of RDB$TRIGGERS.RDB$TRIGGER_TYPE
Author Josef Kokeš
> > Hi!
> >
> > I wonder, is there a documentation of the various
> > RDB$TRIGGERS.RDB$TRIGGER_TYPE values somewhere? The Interbase 6
> > documentation (Language Reference, specifically) lists the values for
> > the regular BEFORE/AFTER INSERT/UPDATE/DELETE, but I can't find values
> > for multi-event triggers, e.g. BEFORE INSERT OR UPDATE. Is there a
> > better way to find them than to create all possible trigger types and
> > see what appears in RDB$TRIGGERS?
> >
> > (I am using these values to translate a database structure to a
> > human-readable form. But even for this limited purpose, I would feel
> > more comfortable with the documented values than experimentally
> obtained.)
>
> Take a look at the content of RDB$TYPES.

I didn't remember about this table! Thanks!

Unfortunately, it only lists the normal (single-action) triggers and the
database-level triggers. At least in all my databases (ranging from FB
1.5 to FB 2.5).

Josef