How to join sys.columns and sys.synonyms table using object_id column
object_id() does not work for remote databases.

The documentation states:


  For objects that are not found in the sys.objects catalog view, obtain
  the object identification numbers by querying the appropriate catalog
  view


SQL that provides an answer to your query requirement is here.