Checking all tables that have a specific column name?

Breako · #1 (**permalink**) 01-05-12, 12:15

Is there a command I can use to tell me all the tables in my schema that have a column name "Id"?

Thanks.

Pat Phelan · #2 (**permalink**) 01-05-12, 12:42

Code:

SELECT TABLE_SCHEMA, TABLE_NAME
   FROM INFORMATION_SCHEMA.COLUMNS
   WHERE  'id' = COLUMN_NAME

-PatP

Brett Kaiser · #3 (**permalink**) 01-05-12, 13:59

Hmmmmm....why do you do it "backwards"?

Pat Phelan · #4 (**permalink**) 01-05-12, 15:20

I work regularly with langauges that get confused about assignment versus comparison. Only two of the languages I've ever dealt with allow you to assign a new value to a constant (in which case Wim would be sorely confused, because 2 very definitely CAN equal 3 there), and fortunately I don't have to work with either of those languages anymore.

Consider my coding style to be an idiocyncracy of an old phart. You should try to do it backwards sometime... It can be fun!

-PatP

Wim · #5 (**permalink**) 01-05-12, 15:54

Quote:

Originally Posted by Pat Phelan

I work regularly with langauges that get confused about assignment versus comparison. Only two of the languages I've ever dealt with allow you to assign a new value to a constant (in which case Wim would be sorely confused, because 2 very definitely CAN equal 3 there), and fortunately I don't have to work with either of those languages anymore.

Have adjusted my Signature.

Quote:

Originally Posted by Pat Phelan

Consider my coding style to be an idiocyncracy of an old phart. You should try to do it backwards sometime... It can be fun!

Backwards? You mean something like this?

Consider my phart to be an idiocyncracy of an old coding style.

"It can be fun!"
Guess I need to practice more.

Pat Phelan · #6 (**permalink**) 01-05-12, 16:28

No doubt about it Wim, that deserves yet another

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech