search database of all tables for one field in table
Keith Lockey
Ranch Hand
Posts: 48
posted 13 years ago
how would I search for a field name that is in one of 200 tables in a database?
Thanks,<br />Keith
Frank Carver
Sheriff
Posts: 6920
posted 13 years ago
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?
