Subject | Re: [firebird-support] Values of RDB$TRIGGERS.RDB$TRIGGER_TYPE |
---|---|
Author | Josef Kokeš |
Post date | 2013-03-22T14:54:28Z |
> > Hi!I didn't remember about this table! Thanks!
> >
> > 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.
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