You need to sign in to do that
Don't have an account?
chuanyi xu
How to know all the fields of the standard objects
I want to know the standard objects's fields, User,Contact and other. How can I view this ?
In sql, I can select * from user. how to query all the fields in salesforce
In sql, I can select * from user. how to query all the fields in salesforce
you can see fields of all the standard objects from this link:
https://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_list.htm
You cant able to use select * from user to view all fields.
You need to put each field in the query or else you can use schema.describe method to acess all the fields on any specific object.
see this link for knowing more about schema.describe method :
https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dynamic_describeSObject.htm
Thanks
Anil.B
All Answers
you can see fields of all the standard objects from this link:
https://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_list.htm
You cant able to use select * from user to view all fields.
You need to put each field in the query or else you can use schema.describe method to acess all the fields on any specific object.
see this link for knowing more about schema.describe method :
https://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dynamic_describeSObject.htm
Thanks
Anil.B
Either you can use Workbench. In workbench all the object's fields are available for quering.
login here with your org login id and password and then click on queries and select the SOQL.
after that select the object name from the list and all the fields are populated in the below list.
http://https://workbench.developerforce.com/login.php
Regards
Virendra