Posted by Ed Murphy on 10/03/07 17:52

Cindy wrote:

> If we had the ability to generate a database table that lists joins
> that were used - imagine a tool where you plug in the names of 4
> tables, for example, and then you get a report where you see all the
> fields, join types, and join type operators that were used between
> those 4 tables - along with the frequency of use. It seems it would
> go a long way toward getting a database in better shape to document
> common relationships.

You might want to run a Profiler trace for a while, send output to a
new table, then query the table for accesses to a table that you're
interested in. You can also look at sysobjects and syscomments to
determine which views access a given table (especially if the Profiler
output cites the view rather than the underlying tables; I've mostly
used Profiler to deal with stored procedures accessing tables directly,
so I don't know the answer to that one without testing it).

[Back to original message]