find out value from unknown field

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

find out value from unknown field

Author

Topic

hongho2
Starting Member

6 Posts

Posted - 2012-11-19 : 09:56:03

Hi,

I have the database contains a lots of tables. I want to find out the specific value but don't know from what table/field contains that value. Is there the way to find out?

Thanks

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-11-19 : 10:12:15

See if this article will help you. http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx

Also, I think RedGate has a (free) product that will let you search in tables (but I might be wrong about it being free).

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources