By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,816 Members | 2,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,816 IT Pros & Developers. It's quick & easy.

Searching across 155 tables

P: 1
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...maybe 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!
Jun 25 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.