0

I want to find the value of a row for my entire database. I don't know what column or table it would be in. I have been trying to find an answer on stackoverflow but cant find anything....

It's Just a Printer Driver
  • 806
  • 4
  • 12
  • 30
  • Which DBMS are you using? Postgres? Oracle? DB2? Firebird? –  Feb 02 '17 at 20:45
  • So you want to search every column of every table for a specific value? Say, 'dog' and it returns a list of tables/columns that contain 'dog'? If so, the answer will be database specific. – Hart CO Feb 02 '17 at 20:47
  • Yeah that would work. I don't mind if its database specific. Microsoft SQL Server Management Studio. – It's Just a Printer Driver Feb 02 '17 at 20:56
  • Possible duplicate of [How do I find a value anywhere in a SQL Server Database?](http://stackoverflow.com/questions/436351/how-do-i-find-a-value-anywhere-in-a-sql-server-database) – KindaTechy Feb 02 '17 at 20:59
  • *Why* do you need to search in all columns/tables? You're working in a DBMS, not an Excel sheet. – dnoeth Feb 02 '17 at 21:04
  • @dnoeth - I once worked on a billing system and I saw some very useful textual information in the application that I just couldn't find in the database. A one-time brute force search seemed like a reasonable solution at that time. – David דודו Markovitz Feb 02 '17 at 21:53

0 Answers0