Subject Re: [firebird-support] Values of RDB$TRIGGERS.RDB$TRIGGER _TYPE
Author Mark Rotteveel
On Fri, 22 Mar 2013 15:44:23 +0100, Josef Kokeš <j.kokes@...>
wrote:
> 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.

Mark