Hello,
I have a SQL database with many tables.
Articles are maintained in the database where a cost center is stored.
I know about the article already the right cost center (4222211) and can narrow down the tables in which the value should be, how can I get out now in which table the value occurs, so I can work with it?
What needs to be done instead of the * so that I get the right table?
So far I have the following:
SELECT Table_name, Column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
Column_name like ‘%Artik%’ and
* like '%4222211%'
I would like afterwards the table name and the column name in which this value stands.
Find the right column
in SQL
Posted
Hello, I have a SQL database with many tables. Articles are maintained in the database where a cost center is stored. I know about the article already the right cost center (4222211) and can narrow down the tables in which the value should be, how can I get out now in which table the value occurs, so I can work with it? What needs to be done instead of the * so that I get the right table? So far I have the following:SELECT Table_name, Column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
Column_name like ‘%Artik%’ and
* like '%4222211%'
I would like afterwards the table name and the column name in which this value stands.