How to Query All Fields in Salesforce

Quick summary

This demo shows how to query all fields in Salesforce using the Developer Console and a SOQL FIELDS(ALL) statement. In just a few steps, you can retrieve every available field for any Salesforce object without manually listing them.

Steps

1. Click the gear icon at the top right menu of the Salesforce dashboard.
2. Select Developer Console from the dropdown menu.
3. In the new window, navigate to the lower part of the console and click Query Editor.
4. In the Query text box, type SELECT FIELDS(ALL) FROM <your object name> LIMIT 200.
5. Click Execute at the bottom left corner of the interface to run the query.
6. Salesforce will process the request and retrieve all available fields for the selected object.