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
Tagged:

Best Answers

  • Sergio RSergio R Posts: 610 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Kazoo60Kazoo60 Posts: 7 Bronze 2
    Yes - from a right click on the DB in SSMS. Is there another way to launch it where the behavior would be different?

    Thanks
  • Sergio RSergio R Posts: 610 Rose Gold 5
    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
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
  • Kazoo60Kazoo60 Posts: 7 Bronze 2
    Work-arounds .... work :-) Thanks!
Sign In or Register to comment.