What tables contain a specific column 1

[glendacom]

I have inherited a database from some where. None of the relationships were defined and no indexes exist. One good thing is that the original designer was good about naming columns consistently. I need to determine what tables specific columns exist in. (For example "what tables contain a column named 'customID'?").

Does anyone know an easy way to do this?

Thanks!

 

[mrdenny]

Use the information_schema views, or the system tables (syscolumns and sysobjects).

More infomation on all three is available from BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[glendacom]

Thanks! the Information_Schema views have done the trick! BOLs are great if you know at least some of the key words to search with and you gave me more than I needed!

 

[mrdenny]

no problem.

Denny

--Anything is possible. All it takes is a little research. (Me)