How can we help you today? How can we help you today?

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

michal7
0

Comments

2 comments

Sort by
  • Tianjiao_Li
    @michal7

    Let me check it with the team and I'll be sure to update you with their inputs.
    Tianjiao_Li
    0
  • 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!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.