CODEWITHSUNDEEP
sql
gillian
gillian

Reputation: 421

finding a relationship accross many tables

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

Upvotes: 4

Views: 158

Answers (1)

Michael Sorens
Michael Sorens

Reputation: 36768

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.

Upvotes: 2

Related Questions