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!
Thanks for your help!
Tagged:
Best Answers
-
Sergio R Posts: 610 Rose Gold 5Hi,
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 -
Kazoo60 Posts: 7 Bronze 2Yes - from a right click on the DB in SSMS. Is there another way to launch it where the behavior would be different?
Thanks -
Sergio R Posts: 610 Rose Gold 5Yes, 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