Q: How to find the table(s) which contain a particular column which I know?
A: Below is the query that would do the trick.
WHERE object_id IN
WHERE name = [columnname] –Column which you would want to locate
This query will return all tables which contains the specific column. And this query also would save your time immensely.