I am using a tool which backsup data from my SFDC instance to local MySQL database. I am concerned with Account and Opportunity object only. But I want to bring all those other objects which are related in any way to Account and Opportunity. Is there any way to determine what objects do Account or Opportunity are related to via any custom or standard field?

  • you'll want to look at schema explorers. Account, in particular is related to many many other objects in the OOTB SFDC org, let alone any customizations you may have done
    – cropredy
    Dec 12, 2016 at 20:45

1 Answer 1


You can use a variety of free metadata search tools like Octopus to see what objects and fields might be related. You can also directly do this by using Schema Explorer in Setup to see what objects are related to Account and Opportunity via lookup relationships. The issue there is that some my have multiple paths that continue beyond the first look-up; particularly with opportunity line items, products and quotes which are things that may not be inherently obvious. I suggest you also take a look at this ERD for Sales Objects and some of the ones that follow in the same document.

  • Octopus looks fabulous for what I am looking for. Ty.
    – r0xette
    Dec 12, 2016 at 21:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .