How to write a query which recursively returns all foreign key references to a column?
Use a recursive CTE, it's essentially no different to the examples that involve HumanResources.Employee, except that you're joining across more tables. Instead of EmployeeIDs, you're collecting object_id and column_id combinations.