searching for columns

[rq]

I'm in the process of integrating 2 apps that use SQL Server 2000. Is there a function or stored procedure that can tell me if a column name is used in another table? E.g., the purchase order id exists in the sales history table; I would like to know if this column name is referred to in another table.

 

[r937]

see Books Online for INFORMATION_SCHEMA

rudy

http://r937.com/

SQL Consulting

 

[ClaireHCM]

also syscolumns

 

[rq]

How can you access syscolumns?

 

[ddeegan]

This is the way I did it through Query Analyzer

SELECT NAME FROM Database#1.DBO.SYSOBJECTS DS WHERE DS.NAME NOT IN
(SELECT NAME FROM Database#2.DBO.SYSOBJECTS)
AND DS.XTYPE='U'

Thanks
Dave