SQL Server - Recursive "find all FK connections for ID through the entire DB" query
How about implementing a child/parent relationship in a table including the hierarchical structure. You could fill that iteratively for every table in your DB, if you add a parent you'd update all its children's hierarchical structure.

To find specific results for a certain table you'd then simply have to select all records that contain that table in its hierarchy.

(Hierachies in your example would look something like this:

/H/B
/H/G/B
/H/B/A
/H/G/B/A
...
)