Export list of nested dependencies of a table

Hi all,

Is there a way to export a list of direct and nested dependencies of an object? 

For example Table t1 -> Stored procedure pr1 -> Stored procedure SP pr2 -> etc

Thank you
Tagged:

Answers

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    Hi mikedavern,

    You can find the export options via the File menu as per the screen shot below:


    To reduce further to an object, you will need to remove the unwanted objects from the diagram and perform the Export.

    Another alternative, is to use Redgate SQL Doc, where you will be able to select the object of interest and generate a document of the object which will include a listing of dependent objects in the 'Uses' and 'Used by' headings.

    Many Thanks
    Eddie


    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.