Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

search database of all tables for one field in table

 
Keith Lockey
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how would I search for a field name that is in one of 200 tables in a database?
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Keith Lockey
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is Oracle 9.0.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic