Dependency on JOIN ON condition

michal7

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

Tianjiao_Li

@michal7

Let me check it with the team and I'll be sure to update you with their inputs.

Tianjiao_Li

@michal7

Thanks for your patience.

It looks like this is a feature request, and we'll be sure to make the product team aware!