Search for a column name in sql db

SELECT dbo.sysobjects.Name FROM dbo.syscolumns

INNER JOIN dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.ID

WHERE dbo.syscolumns.Name = 'UserID' --and dbo.syscolumns.xtype = 175

--AND dbo.sysobjects.type = 'U'