Are field names and object names in a SOQL query case sensitive?


  • The field names used in an object's SOQL select statements are case-insensitive. Therefore, the query: "SELECT id, NAme FROM Account" should be correct.

  • The object names used in SOQL are case-sensitive. Therefore, the query: "SELECT id, Name FROM ACCOUNT" may not be handled correctly.

Despite this, there are several exceptions where the case of SOQL fields is important:

  • For Fields Mapping and Data Anonymization, you need to specify fields and object names exactly as they are case-sensitive.
  • When listing sObject field(s) in an externalId setting, it is crucial to ensure that the fields are spelled correctly, as this setting is case-sensitive.
Last updated on 18th Apr 2024