How To Get a List of All Your Salesforce Objects & Fields

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 https://schemalister.herokuapp.com/, 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

References & Useful URLs
Change Log
  • 02-Dec-2014 – Blog Post created
  • 11-Apr-2020 – Added link to Blog Post ‘How to Report on Objects and Fields Defined in Salesforce’
  • 28-Oct-2020 – Removed one of the URLs no longer working 

8 thoughts on “How To Get a List of All Your Salesforce Objects & Fields”

  1. I followed the steps, but the report doesn’t give me objects. When I select label, it returns contract history or task history.

  2. Thanks Ashish. Is it possible to get the description as well ? If yes… Please let me know the process to get it done.

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top