Newbie question.

How does one get the table name for your object? Or is there a way to get the list of all the available table names with soql?

3 Answers 3


Go to: Setup.

On the left, you will have the navigation pane. Go to: Create -> Objects.

Select your object and the object name should show up. enter image description here

  • Great. So for that example let's say there's a field "Name". To query that i would do something like: Select name from MyCustomObj__c correct?
    – chrisjlee
    Mar 19, 2015 at 14:20
  • @chrisjlee Yes, that is correct.
    – dphil
    Mar 19, 2015 at 16:26

The table name is really the object API name. So for any custom object you have to define that on creation. You can see the API name of any custom object by going to Setup > Create > Object > Pick the object you want > Look at the "API Name" field.

For the SF delivered objects (I.E Account, Lead, Contact), the table name is just the object name.

Good luck!

Luis Luciani


I don't know of a direct query to retrieve all of the available table names in your Salesforce instance. If you use a third party query tool though, you will be able to see all of the objects. I use SoqlXplorer, but Workbench or another query tool should work as well.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .