find all tables in server with specific column name

select       *
from         information_schema.columns  C
where
                COLUMN_NAME like '%COLUMN_NAME %'