11 Replies Latest reply: Apr 10, 2013 10:35 PM by 860675 RSS

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

    675283
      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