SQL para encontrar tabelas com certo campo.

findfield.sql

DECLARE @Busca VARCHAR(8000)
SET @Busca = 'campo'

SELECT
        Colunas.COLUMN_NAME,
        Tabelas.TABLE_NAME
FROM
        INFORMATION_SCHEMA.TABLES Tabelas
        INNER JOIN INFORMATION_SCHEMA.COLUMNS Colunas
        ON Tabelas.TABLE_NAME = Colunas.TABLE_NAME

WHERE
         (Tabelas.TABLE_TYPE='BASE TABLE') AND
         (
                  (Tabelas.TABLE_NAME LIKE '%' + @Busca + '%') OR
                  (Colunas.COLUMN_NAME LIKE '%' + @Busca + '%')
         )

ORDER BY 
Tabelas.TABLE_NAME ASC