|
Hello, Please let me know script or procedure to serach full database for a column value available in all tables.
(comments are locked)
|
|
You may want to look at http://www.sqlservercentral.com/articles/Search/64877/ It is an article I wrote some time ago that addresses this topic.
(comments are locked)
|
|
Hello, Sorry for confusion..... Thanks for ur answers.... Im looking for a script or procedure for physical values serach....... John u rite.....im looking for physical values serach....... eg the word "apple" in any text column from all tables available in a database. Thanks Geeta Tim's article is your solution... Just loop through the function example he has given and pass it each of your tables... He is using the newer INFORMATIONSCHEMA objects that I don't believe are supported in SQL 2000... However, you can substitute them for the similar SYSOBJECTS and SYSCOLUMNS tables that are supported in SLQ 2000.
May 15 '10 at 10:53 AM
John Franklin
(comments are locked)
|
Are you asking for a physical value search (i.e. - the word "apple" in any text column of any table) or for a listing of all tables that contain a similarly named column (i.e. - all tables that contain a column name like "fruit")?
Please provide more details. Would you like to look for occurence of a specific string value across all suitable columns of all available tables in the database? If so I can write you a select statement generating the queries you need.