Post reply

dependencies across datbases

  • July 27, 2004 at 6:15 am

    #88356

    In enterprise manager when I check dependencies it only shows them within the current database. How can I show dependencies where tables are joined from other databases?

    Thanks.

  • July 27, 2004 at 7:00 am

    #516284

    There are no dependencies across databases physically.  You can write a procedure to "look for" the logical dependencies between databases, but that would be pretty hard unless you've really been consistent on how you name your foreign keys, column names, and tables.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply