Finding dependency between objects

Bartakke Kiran

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?

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.