Link to home
Create AccountLog in
Avatar of dstjohnjr
dstjohnjrFlag for United States of America

asked on

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

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.
Avatar of Bradley Haynes
Bradley Haynes
Flag of United States of America image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of dstjohnjr


That works!  Thank you!