finding a relationship accross many tables

Question

Hi

I've inherited a development with nearly 800 tables. I need to produce reports that span multiple tables. I'm usong the likes of SQL Dependency Tracker to help me find the required tables, but even this is painful.

Do you know of a app that I can say [start table] [end table] now find me all the tables inbetween?

Any ideas? Thanks

Answer 1

I realize you are looking for a finished app to do the job, but in case you do not find one better than SQL Dependency Tracker, here is a tip to get you started writing your own:

For SQL Server, Listing SQL Server Object Dependencies describes 4 different ways to programmatically determine immediate neighbors. SQL script to list table dependencies provides a complete script to do this in Oracle (though unfortunately this Oracle solution requires membership in Experts Exchange to see the answer.)

These allow you to get immediate neighbors so you would need additional coding to repeat-and-search until you get to the final target you wish to connect.