Search all columns in list of tables for particular string I have a list of market data tables in one of our environments and need to search every column in the list for a certain string. Can anyone point me in the right direction. 

1&gt; select @@version
2&gt; go



  Adaptive Server Enterprise/15.0.3/EBF 16558 ESD#1/P/Solaris AMD64/OS 5.10/


Thanks
You can query syscolumns and sysobjects in each database to get the information you need.

select 
  distinct so.name as TABLE_NAME,
  sc.name as COLUMN_NAME
from 
  syscolumns sc,
  sysobjects so
where 
  sc.id = so.id
and   sc.name like '%searchstring%'
order by so.name


If you need to limit your search to specific tables, then you can add an additional 'and' clause:

and so.name in ("Table1","Table2","Table3")