I'm not sure I understand. If the value you want to find is "Aashish" will "Aashish" be a field name in a table, a value in a field in any table, or what? Are you looking to find all fields in all tables named lname? Or are you searching all fields in all tables for a value like "John Smith" or something?


>Hi friends,
>
>I wish to search a value of a field in a database which has 250+ tables. Any prg,class or util.
>
>Example:
>
>Need to find value 'SMITH' to know which all tables of database consist of this value.
>
>Any ideas?