Hi Tracy,
I am trying to search all fields in all tables for a value 'Aashish Sharma' or 'John Smith'
>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?