How to display the relevant columns by searching a value using SQL statements

Question

Example:
Database1, Database2, Database3,
Table1, Table2, Table3
Column1, Column2, Column3

In the above database structure, I am not sure where all the places (tables and columns) the value "Value1" is associated.

So please guide me the SQL statements where I can locate the linked tables and columns which is holding the value "Value1".

Answer 1

I suggest you looking into union