How to find the specific value in Z table without knowing the column name
I need your help to fix the following scenario.
Scenario: I have more than 10 table and each table has different column names (column number also different). I need to check specific value is present in the 10 table. Its like a similar kind of find option.
|Source_ 1||Source_ 2||Source_3||Source_ 4|
For Example: I need to display the table Name if the table contains 'A' in any column. (Note we don't know the column name)
Please help me to fix this.
- I have tried where condition but for the where condition we need to know the column name.
- Just want to display the table name if contains specific value, no further action is required.