What are the challenges you face when working across database platforms? Take the survey
Options

Finding dependency between objects

Bartakke KiranBartakke Kiran Posts: 2
edited June 22, 2011 6:33AM in SQL Dependency Tracker
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?

Comments

  • Options
    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
Sign In or Register to comment.