Identify all tables using column name: CUST_ID??? 1

[btturner]

fyi, I need to identify all tables in my Prod DB which use column "CUST_ID"

Can you please help me w/ a query... which will identify all SQL Server 2k tables (in a single database) which use this column name?

thanks!

 

[tlbroadbent]

Select *
From information_schema.columns
Where column_name='cust_id' Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Grimey]

This works for me in SQL7...

USE ProdDB

SELECT C.Name, T.Name
FROM syscolumns C
INNER JOIN sysobjects T
ON C.id = T.id
WHERE C.name='CUST_ID'


HTH,

Grimey