We help IT Professionals succeed at work.

SQL Query to search for a specific value in a database where table and field names are unknown

dstjohnjr
dstjohnjr asked
on
2,479 Views
Last Modified: 2008-06-05
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.
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
That works!  Thank you!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.