How can we help you today? How can we help you today?

Finding dependency between objects

I am trying to find the dependencies between the database objects and I come to know that ool shows only those dependencies which are written into DB metadata.
For example, if you create SP which callls other Sp (child) which weren't created yet (or not saved to DB yet), it will miss such dependency.

Is there any way to find such dependencies?
Bartakke Kiran
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    It sounds like you're more looking to find invalid references to objects in your schema, rather than dependencies between objects.

    We have another tool called SQL Prompt 5 which has a feature called 'find invalid objects'. When you run this it will search through your database and find any objects that have bad references. i.e. references to missing columns in views, stored procedures that don't exist etc.

    This might be what you're looking for.

    I hope this helps.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.