wood burning stoves 2.0*
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: search database of all tables for one field in table
 
Similar Threads
Logic problem
building a searching tool for jsp pages
How to provide willdcard search
tables and fields
One java class & Two tables Hibernate