Subject Procedures that operate on a given table
Author Eduardo Resek
For component development purposes, I need to grab all procedures that
perform each of the UID operations on a given table. From the
RDB$DEPENDENCIES system table I can get the procedure names, but not what
they do. I have tried to select from RDB$PROCEDURES filtering out those
whose body (RDB$PROCEDURE_SOURCE contains 'DELETE FROM <TABLE_NAME>, etc.,
but this is obviously misleading, as there can be commented code in
procedure's text, or the words can be split across lines. Does anybody know
about a precise method for that?



Thanks in advance.



Eduardo





[Non-text portions of this message have been removed]