| 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: 6913
|
|
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?
|
A Convergent Visionary ~ Frank's Punchbarrel Blog ~ LinkedIn profile
|
|
Keith Lockey
Ranch Hand
Joined: Oct 05, 2001
Posts: 48
|
|
|
It is Oracle 9.0.
|
|
 |
|
|
subject: search database of all tables for one field in table
|
|
|
0
