1

I want to search for all tables and columns containing specific value .

Like , 

Select * from [All_Tables] where [AnyColumn] = 'MyValue'
Simsons
  • 12,295
  • 42
  • 153
  • 269
  • This was asked before [here][1]; the referenced script should work for you. [1]: http://stackoverflow.com/questions/1796506/search-all-tables-all-columns-for-a-specific-value-sql-server – cciotti Feb 13 '13 at 11:23
  • http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm – Raab Feb 13 '13 at 11:25

1 Answers1

2

If you are using PL/SQl tool, then you can search for the object that you are looking for. The tool provides the gui wherein you can enter the keyword you are looking for. Say, in your case, search for 'MyValue'.

Madhusoodan
  • 560
  • 1
  • 6
  • 18