Subject Re: [firebird-support] FB 2.0: Blank triggers
Author Milan Babuskov
red_october_canada wrote:
> When I use FlameRobin to pull up the DDL on my FB DB, I notice that
> there are triggers on tables that I did not explicitly create. They
> have names like CHECK_1, CHECK_15. I examine the SYSTEM table
> RDB$TRIGGERS and find that the RDB$TRIGGER_SOURCE field for these
> triggers is null.
>
> What are these triggers? Why are they there?

As Dmitry wrote, those are triggers for check constraints.

However, they should not be shown. Could you tell us the versions of
Firebird, FlameRobin and show the DDL for those checks and perhaps those
rows from RDB$TRIGGERS.

Feel free to contact me directly or join flamerobin mailing list:

https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

Thanks,

--
Milan Babuskov
http://www.flamerobin.org