How do you get a list of all the objects and fields in your Salesforce instance? If you have worked on Oracle, you can query views like DBA_TABLES & DBA_TAB_COLUMNS, if you have worked on SQL Server you can query SYS.TABLES & SYS.COLUMNS. Unfortunately, there isn’t a similar simple way in Salesforce. With Salesforce you need to use Metadata APIs and write a few lines of code to get the details.

You can try Schema Lister developed by one of the developers at Tquila. Navigate to URL, select your environment and API version, authorise the Apps through OAuth and it will generate a list of all the objects and fields. The benefit of using this app is that you don’t need to install anything in your Salesforce org and don’t need to provide your Salesforce username and password (as the app uses OAuth to connect to Salesforce)

Tquila Schema Lister

You may also want to read Tquila’s blog post on Schema Lister to get more details. Or click here to explore some of the similar applications on AppExchange.

[11-Apr-2020] – You can now also create a report on object and fields definition in Salesforce and here is another blog post on that – How to Report on Objects and Fields Defined in Salesforce