How to view object dependencies with Toad for Oracle

This article will show you how to view specific object dependencies in Toad for Oracle.

Open Schema Browser from Database menu in toolbar.

In schema browser search for object which dependencies you want to know and click on it. In object details switch to:

  • Deps (Uses) - to see on which object selected object depends

  • Deps (Used by) - to see which objects depends on selected object

  • Used By - shows objects depending on selected object

You can easily view place where this dependency is defined by checking Show Context option and selecting object. Below list of dependency should appear new editor window that contains appropriate object definition with highlighted place where dependency is created.

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