SQL Query to search for a specific value in a database where table and field names are unknown
Posted on 2007-10-08
I have a rather large database that contains about 3500 tables. I have a specific value that exists in one of the fields in side one of the tables but don't have a clue as to which table, much less field. Is there a way to mine this data using some sort of a SQL query? Consequently, the value I am searching for is 200611.
TIA for any guidance at all!
Oh, and this is for SQL Server 2000.