Schema Explorer

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 Force.com 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 Force.com 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 Force.com SOQL and SOSL Reference.