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

How are FK dependencies reported in "Used By"

I'm a new user of SQL Doc. I'm not understanding the dependency reporting. I have a master table called "Payment Type". The PK of that table is a FK on "Payment" . When looking at the "Used by" section of the documentation on Payment Type however, it is blank. I would have expected it would show as being "used by" the Payment table given it is a FK there. Is this a bug or is there another explanation. See screen shots of that section of the report for both tables (attached)>

Thanks for your help!

8qfp1qkvck9h.png
d9f65b3c9ptq.png
Kazoo60
0

Comments

4 comments

Sort by
  • Sergio R
    Hi,

    This appears to be a bug, are you launching SQL Doc from SSMS by choosing "Document [database]..." from the database's context menu?

    Thank you,
    Sergio R
    0
  • Kazoo60
    Yes - from a right click on the DB in SSMS. Is there another way to launch it where the behavior would be different?

    Thanks
    Kazoo60
    0
  • Sergio R
    Yes, if you start SQL Doc and then connect to the DB from there you shouldn't have that issue.
    Also the bug only affects the preview, on the generated documentation this will be ok.
    Sergio R
    0
  • Kazoo60
    Work-arounds .... work :-) Thanks!
    Kazoo60
    0

Add comment

Please sign in to leave a comment.