Thanks PAVB for replying back .

No i dont know column names ..I am looking for tables names and column names that has a particular value in it. for example the reuslt shld look like this

Table column value
table1 column1 abc
table 4 column10 abc
table6 column3 abc

does it make sense?

thanks!