In quali tabelle di un database ricorre uno spicifico campo.

SELECT sysobjects.name
FROM syscolumns LEFT JOIN sysobjects ON sysobjects.id = syscolumns.id
WHERE syscolumns.name LIKE 'myFieldName'
ORDER BY 1