Dependency on JOIN ON condition

Dear members,

I tried it to map dependencies of SQL stored procedure via SQL Dependency Tracker. 

It found all the related objects, however it does not show the key the objects are related by. Without the conditions (example [dbo].[Customers] is linked in the procedure with the [dbo].[CustomersContact] on the [dbo].[Customers].[Id] = [dbo].[CustomersContact].[CustomerId] condition etc.) it is useless for our purposes.

There is no PK or FK on the tables, however the relation is defined by the ON condition of INNER JOIN inside the Stored procedure.

Is there a way it can be included by the SQL Dependency Tracker in the diagram and/or dependency list?

Thank you, Michal



Sign In or Register to comment.