Ronald,

r> 1. How can I get all Names of the Stored Procedures and Triggers in a
r> Database?

r> 2. How can I get the complete content of the Stored Procedure /
r> Trigger if I have the name?

r> 3. How can I detect any dependencies on a table?

all your questions are answered by a combination of SchemaCache and
the system tables. The former is documented in IBO's help file, the
latter you'll find in IB/Fb documentation.

HTH
--
Nando mailto:nandod@...