How can I view all the available tables in my Salesforce instance using SOQL? Is it possible to view additional parameters, such as whether the table is queryable, or whether it is customizable?
Asked
Active
Viewed 1,267 times
0
-
Duplicate of https://stackoverflow.com/questions/60066774/querying-salesforce-object-column-names-w-soql?noredirect=1&lq=1 – Eugene Jun 21 '23 at 01:22
1 Answers
3
EntityDefinition is a decent start (experiment with the WHERE clause, there are way more tables even in vanilla SF than you think)
SELECT KeyPrefix, QualifiedApiName, Label, IsQueryable, IsDeprecatedAndHidden, IsCustomSetting
FROM EntityDefinition
WHERE IsCustomizable = true AND IsCustomSetting = false
eyescream
- 18,088
- 2
- 34
- 46
-
Hi again Is there any query or something where we can get or view the fields of the table of salesforce? – Sidra Asghar Oct 09 '20 at 10:30
-
1Yep, `FieldDefinition`. For example https://stackoverflow.com/a/60067076/313628 – eyescream Oct 09 '20 at 13:31