Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    TN
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Documenting Dependent Queries (2002)

    Is there a way to get a list of all queries which are dependent on a particular table within a database? I've scoured the newsgroups and been unable to find anything on this. I've played with the MsysObjects table and run queries against it to get helpful information but what I'm seeking doesn't appear to be available with it. We have some large databases at work with many tables and queries and we need to determine which queries will be affected before deleting a particular table. Thanks.

    W. Alan Lemly

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Documenting Dependent Queries (2002)

    There are add-ins that can search for the occurrence of a specified string in database objects, in your case search for the occurrence of the name of a table in queries.
    For example: Find and Replace from Rick Fisher and Speed Ferret from Black Moshannon Systems. Both offer a limited free trial download.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •