Hello,

> which is sql that I use to find the name of a foregin key only
> knowing the table and field name that the foregin key makes
> reference.

Check RDB$REF_CONSTRAINTS, RDB$TABLE_CONSTRAINTS,
RDB$INDICES and RDB$INDEX_SEGMENTS.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com