How to find a Generator associated with a field

[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...

[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.

[pwatel]

does the metadata component lists triggers ???
if it does not why not in the next release ???
PW

[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