Este comando abaixo irá lista todas as tabelas
SELECT
T.name AS Tabela,
C.name AS Coluna
FROM
sys.sysobjects AS T (NOLOCK)
INNER JOIN sys.all_columns AS C (NOLOCK) ON T.id = C.object_id AND T.XTYPE = 'U'
WHERE
C.NAME LIKE '%NOME_COLUNA%'
ORDER BY
T.name ASC
Créditos: https://social.msdn.microsoft.com/Forums/pt-BR/4426106f-a22c-456f-b463-67620bfda1ef/como-procurar-pelo-nome-de-um-campo-em-todas-as-tabelas-de-um-banco-?forum=520
