CODEWITHSUNDEEP
sql-server-2005
Lijo
Lijo

Reputation: 107

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 value 'xyzeee'.

Is there a query to achieve this?

Thanks

Lijo

Upvotes: 0

Views: 104

Answers (2)

Martin Smith
Martin Smith

Reputation: 453287

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

Upvotes: 1

TomTom
TomTom

Reputation: 62093

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.

Upvotes: 0

Related Questions