This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes search database of all tables for one field in table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "search database of all tables for one field in table" Watch "search database of all tables for one field in table" New topic
Author

search database of all tables for one field in table

Keith Lockey
Ranch Hand

Joined: Oct 05, 2001
Posts: 48
how would I search for a field name that is in one of 200 tables in a database?


Thanks,<br />Keith
Frank Carver
Sheriff

Joined: Jan 07, 1999
Posts: 6920
Depends on the database really. Most databases keep the information about the fields and tables in a special table, so you can just issue a query on that table.
Can you tell us a little more about what sort of setup you are working with?


Read about me at frankcarver.me ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
Keith Lockey
Ranch Hand

Joined: Oct 05, 2001
Posts: 48
It is Oracle 9.0.
 
GeeCON Prague 2014
 
subject: search database of all tables for one field in table