This discussion is archived
11 Replies Latest reply: Apr 10, 2013 8:35 PM by 860675 RSS

How to search all columns of all tables in a database for a keyword?

675283 Newbie
Currently Being Moderated
Dear Team,

i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text.

example :

table 1: columns data
empname sam
empid 01

table 2 columns data
deptname sam
departmentid 10

table 3 columns data
organization name sam
organization id 1

when i search for text " SAM"

it should search me from the entire database, all tables and columns of it and display the result

output : tablename cloumn value
table1 empname sam
table2 deptname sam
table3 organizationame sam


the example is just an sample not the real data .

please help me with sample code or any link related to it .


thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points