Schema Builder provides a dynamic environment for viewing and modifying all the objects and relationships in our Salesforce application. It simplifies the tasks of designing, implementing, and modifying your data schema. In Schema builder, we can view our existing schema and interactively add new custom objects, custom fields, and relationships simply by dragging and dropping technique.
In Salesforce Schema Builder automatically implements the changes and saves the layout of your schema any time you move an object. Schema builder also provides details such as field values, required fields, and how objects are related by displaying lookup and master-detail relationships. We can view the fields and relationships for both standard objects and custom objects.
To open schema builder in Salesforce, navigate to Setup | Build | Scheme Builder.
In Salesforce, Schema builder is enabled by default and lets users add custom objects, Lookup Relationships, and all custom fields except geolocation to your schema.
From the Objects Palette select the Objects. For example here we are taking Account, Contact and Opportunity.
As shown above we have three standard objects and they have some relationships with each other. We can move objects to any place in Schema Builder.
- Blue connections are lookup relationships.
- Red connections are master-detail relationship
Creating objects using Schema Builder
To create objects and fields go to the Elements tab, Just drag the object element to create a new object. It prompts you to fill in the details of the object. Fill in the detail.
Click on Save.
From this drop-down, we can Hide Objects on Canvas, Edit Object Properties, Delete objects, and view Objects and their Page Layouts.