Object Dependencies (General Page)

Some database objects have dependencies upon other database objects. For instance, views and many stored procedures depend upon the existence of tables that contain the data. The Object Dependencies (General Page) for the current object lists both the other database objects that must be present for the object to function properly and the objects that depend upon the selected object.

Use this dialog box to understand the dependencies before changing or deleting the selected object.

  • Objects that depend on <selected object>
    Clicking this button displays a list of those objects that are dependency-tracked and that depend on the selected object.
  • Objects on which <selected object> depends
    Clicking this button displays a list of those objects that are dependency-tracked, on which the selected object depends.
  • Dependencies
    If Objects that depend on <selected object> is clicked, this displays an hierarchical view of objects that depend on the selected object. If Objects on which <selected object> depends is clicked, this displays an hierarchical view of objects on which the selected object depends.
  • Name
    Displays the name of the object selected in the Dependencies tree view above.
  • Type
    Displays the type of the object selected in the Dependencies tree view above.