Search whole database instead of single table

Question

I want to find a number or string in a very large database. Is there any way to make an SQL Query that searches the entire database, and not just a single table?

I'm looking for something like:

select * from *;

Heidisql has the ability to search an entire databse,probably other clients as well. — Mihai, Mar 26 '14 at 13:37
apex sql tools has a feature that does this http://www.apexsql.com/sql_tools_search.aspx — RoughPlace, Mar 26 '14 at 13:38

score 3 · Accepted Answer · edited May 23 '17 at 12:06

3

If you are using SQL Server this post from kd7 might be what you're looking for: How do I find a value anywhere in a SQL Server Database?

edited May 23 '17 at 12:06

Community

1
1

answered Mar 26 '14 at 13:43

xeraphim

3,955
8
44
89

Search whole database instead of single table

1 Answers1