Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    Unanswered: Tables used by a sql query

    I want to get the list of tables which an SQL query is using.It should be an automated solution
    It could be through some query or parser written in jruby or R or any other language,any thrd party tool(freeware)or any scripts.

  2. #2
    Join Date
    Oct 2009
    221B Baker St.
    Good luck.

    I've not heard of anything that will identify every table "hit" when all of the pieces of a query are run (i.e. stored procedures, user-defined functions, triggers, etc).

    You might also look here:
    SQL Server Query Execution Plan Analysis - SQL Server Performance
    and see if this will help.

Posting Permissions

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