Finding columns in SQL database

[Alsy]

Dear Tek Tips

How can I find a particular column in a nnmber of tables.

For example, I have column name , grporder and I want to know which one of the 100 tables it is in...is there a quick way of finding that out?

There is probably something very simple, but I can't see it at the moment

 

[r937]

SELECT table_name
  FROM information_schema.columns
 WHERE column_name = 'grporder'

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[Alsy]

That has worked fine...thank you verymuch