Page 1 of 1

How to find a Generator associated with a field

Posted: Fri 22 May 2009 11:37
by pwatel
Is there a way to find out the generator name associated with
a field in a specific table
using either the metadata component or other techniques
thanks
Philippe Watel
Ps now I am not on trial - I am officially a customer
email [email protected] etc...

Posted: Mon 25 May 2009 08:41
by Plash
You can use the RDB$TRIGGERS system table to find all triggers for the specified table. Then use RDB$DEPENDENCIES to find generators the triggers depend on.

using the meta component

Posted: Mon 25 May 2009 12:57
by pwatel
does the metadata component lists triggers ???
if it does not why not in the next release ???
PW

Posted: Tue 26 May 2009 06:44
by Plash
The TIBCMetaData component does not list triggers. We are not planning to add this feature in the next release.

You can list triggers by the following query:

SELECT * FROM RDB$TRIGGERS