How to list all columns of tables having a certain column named

[Ben Rendel]

Hi

I'm trying to list all columns of tables having a column named 'ContactService ID'

The following code does not work
error: Invalid object name 'sysobjects.nam e'

use MSSmallBusiness
SELECT table_name=sysobjects.name,
       column_name=syscolumns.name
    FROM sysobjects
    JOIN syscolumns ON sysobjects.id = syscolumns.id
    WHERE exists ( select ContactServiceID from sysobjects.name )
   ORDER BY sysobjects.name,syscolumns.colid

I would appreciate getting help to make it work

Thanks
Ben

[ck9663]

Here, try this...

SELECT table_name=sysobjects.name, column_name=syscolumns.name
FROM sysobjects
   JOIN syscolumns ON sysobjects.id = syscolumns.id and syscolumns.name  = 'ContactServiceID'
ORDER BY sysobjects.name,syscolumns.colid

Happy Coding!!!

~~ CK