Looking for a tool for Data Mining

[Veneficus]

Hi Techies,

I am looking for a tool that would go through all the fields of all the tables in a database (SQL in my case) and search for a specific string and give me a list that which tables and fields have that info.

I can write something to accomplish this but I bet there is a product out there that would do what I want to do.

Do you aware of any product that accomplishes what I ask for?

Thanks,
Ven

 

[markphsd]

Well, have you tried pivot tables?
You can use constraints with sql to build one. You could use a table full of constraints and tie it into the query that creates the pivottable.


Mark P.

Bleh