How to identify look up relations to an object in Salesforce

You could get this with apex describe methods:

for ( Schema.ChildRelationship scr : Account.sObjectType.getDescribe().getchildRelationships() ){
    system.debug('');
    system.debug('**** Child SObject         **** ' + scr.getChildSObject());
    system.debug('     Field                 **** ' + scr.getField());
    system.debug('     Relationship Name     **** ' + scr.getRelationshipName());
    system.debug('     Cascade Delete        **** ' + scr.isCascadeDelete());
    system.debug('     Deprecated and Hidden **** ' + scr.isDeprecatedAndHidden());
    system.debug('     Restricted Delete     **** ' + scr.isRestrictedDelete());
}

Or if you want a visualization of the object relations, the schema builder is a nice tool.


There are couple of tools thats very helpful

1.Workbench

You can see the Childrelationships to see all the all the objects for which the object is looked upto

enter image description here

2.Appexchange app named Schema Surfer

This app has logical arrangement of your metadata to help you figure all child objects


You can also use Etherios EasyDescribe - Free MetaData Viewer/Extractor from AppExchange which is shown below. You can also export the result to excel format.enter image description here

And also it has many other features.