Searching Tables in a Database

[tgtfranz]

Hi,

Does anyone out there know of a way to search a database for tables for a specific field. Right now I am looking through these one by one and it is getting painful.

I know there are tools out there for doing this in sprocs like sp_search and sp_search_code but these are just for stored procedures and not the rest of the objects.

Thanks
tgtfranz

 

[DotNetGnat]

Select * from information_schema.columns where column_name LIKE '%yoursearchstringhere%"

-DNG

 

[tgtfranz]

Thank you DNG,

This is EXACTLY what I was looking for and it is so simple. Leave it to me to over complicate things.