SQL Server DB metadata

I am using SQL Server 2005. I have a requirement to list out all the tables (and the column) whcih has the v开发者_C百科alue 'xyzeee'.

Is there a query to achieve this?

Thanks

Lijo

In answer to your question see here http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

No, wont ever be. This is not doable in one query. You will have to do a LOT of SQL statements in a stored procedure for that.

Is this some homework?

Or - are your requirements more specific than that? I somehow see no sense in this type of query to begin with. I gladly will help you further, but a little more context would be nice.