Searching across 155 tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tmdb57
    New Member
    • Jun 2008
    • 1

    Searching across 155 tables

    I need to search for different names that may or may not exist in each of the tables in a database that contains 155 tables. The fields may not be named the same, and, the search names may exist in several different fields in the table, or not at all. I probably could use a web app to do this but don't really have the time. I remember doing this long ago with such great tools as Tcl, AOLServer, and ADP but I sure don't have time to get into all of that. Any quick ideas just using simple query tools? I downloaded a trial of EMS SQL Query but still have not found the solution...mayb e a stored procedure? I am a little rusty with all of this so am hoping there is an easy answer that I am forgetting. Thanks in advance!
Working...