Schema Explorer

Force.com IDE is in a maintenance-only state. We still provide support for the product through our official channels, but updates prior to October 12, 2019 will be only for critical security issues that arise. On October 12, 2019, we will no longer provide support or updates of any kind for Force.com IDE. On that date, we will also begin archiving documentation and removing download links for the product. We recommend that you start migrating to Salesforce Extensions for Visual Studio Code or one of the great tools made by our partners. For more information, see The Future of Salesforce IDEs on the Salesforce Developers Blog.

Warning

The Schema Explorer is a tool for browsing the metadata of a Salesforce organization, and for querying data. The Schema Explorer presents the logged-in user's view of the Salesforce data model, including object visibility, permissions, data types, lookup values and other information that is useful in developing applications on the Lightning Platform.

The Schema Explorer provides a hierarchical tree view of your organization's schema. Every object that can be accessed by the logged-in user is displayed at the root level of the tree, with additional related properties beneath those roots. Tooltips provide quick summary information.

The Schema Explorer is read-only. You can query data in the schema, but you cannot modify your schema through the Schema Explorer.

Note

To open the Schema Explorer:
  1. In the Package Explorer, expand the node for your project.
  2. Double-click salesforce.schema.
To create a query:
  1. Expand the Schema objects in the tree view and select the objects or fields you want to query on.
  2. Click Run Me.
  3. You can also create a query by entering SOQL directly in the Query Results window. For example, to search for all the accounts in your organization that start with the letter B, enter the following SOQL query:
    1SELECT Name FROM Account WHERE Name LIKE 'B%'

For more information about how to write SOQL queries, see the SOQL and SOSL Reference.