Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search all tables inside a database

Status
Not open for further replies.

jammer1221

Programmer
Joined
Jul 30, 2003
Messages
352
Location
US
Hi,
I was wondering if it was possibly to search through all the tables inside of a database...Like say I have a database named file_test and the tables i want to search in are a, b, and c...do I have to do each one individually or is there a way I can do it all in one query...What im trying to do is search for a certain search word inside of several tables.
Thanks for the help in advance
Jammer1221
 
welp nevermind guys i figured it out...you have to use a loop and an array..atleast thats how i did it...if you have any suggestions or would like to know what i did just post back here id be happy to tell ya
Jammer1221
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top