Export list of nested dependencies of a table

mikedavem

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

Eddie D

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