Query to find a specific field ina a single databse
Posted on 2006-07-05
I am in need of a solution to find a specific field, and how many times it is used, referenced throughout a databse
There are 2064 tables in databse A - I want to find out which tables have the 'company' field in this database. Is there a query that can be written to find all of the tables that use 'company' as a field in databse A. I do not care what the data is at this time, just want to know the location of the field without having to query each table.
Thank you in advance for your assistance.