Table of Contents:


    Follow us

    How to view object dependencies with Aqua Data Studio

    Bart Gawrych - Dataedo Team Bart Gawrych 2019-04-12 2019-05-09
    This applies to Aqua Data Studio. Article available also for: Toad for Oracle IBM Data Studio

    This article will show you how to view a specific object's dependencies using Aqua Data Studio.

    Open Server Panel by clicking on Servers (Fig. 1 [1]) tab or Window -> Show/Hide Server Panel (Fig. 1 [2]).

    Fig. 1. Server Panel visibility options

    Find the object which dependencies you want to view by expanding branches of the Server Panel. Then, expand its Dependencies branch.

    Fig. 2. Dependencies in Server Panel explorer

    In Referenced by branch you can find objects which use selected object and outside this branch are objects used by the selected object.

    Another way to view dependencies is to right click on the object (e.g. table) and select Table Properties (or Function properties for functions etc.) option. In the Details window switch to Dependencies tab. You will see two fields:

    • Objects that depend on selected object
    • Object on which selected object depends on

    Fig. 3. Dependencies in Object Properties window

    Share this article

    0
    There are no comments. Click here to write the first comment.