Jump to content

Find the right column


Dennis Fürbach
 Share

Recommended Posts

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.

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...