How to find all relation of a user in a SQL database?

I want to find all tables pointing to a specific user in a SQL database.

Consider table users with one column id as primary.

How would I find all tables that have reference to a specific user with the user id primary.