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.
| Author |
Topic |
|
sujithukvl@gmail.com
Starting Member
22 Posts |
 Posted - 2012-02-11 : 12:16:50
|
| I have a database with 100 tables. how can i know which table contain a particular text.For example which table contains text 'Assumed Life Claims'I can give a hint that, this filed is a varchar |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-11 : 12:37:09
|
| Take a look at this blog - the scripts there may be useful to you: http://beyondrelational.com/blogs/naomi/archive/2010/10/29/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx |
 |
|
|
sujithukvl@gmail.com
Starting Member
22 Posts |
Posted - 2012-02-11 : 13:01:52
|
| Thank you how can mark you post as answerfrom the link u given i could navigate tohttp://vyaskn.tripod.com/search_all_columns_in_all_tables.htm |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-11 : 17:24:57
|
| Unlike some other forums, SQL Team does not have the concept of marking a question as having been answered. |
|
|
|
|
|
|
Which table contain this data+ SQL