Select FIELDS (All, Standard, and Custom fields) in SOQL Query

Hello All,

Earlier Query all fields functionality was not available in Salesforce. Now we can get records of all fields available in Salesforce using the new FIELDS() function of Salesforce Object Query Language (SOQL).

FIELDS(ALL) – All Fields including custom and standard fields. This is like * in SQL.

FIELDS(Custom) – This will fetch only custom fields.

FIELDS(Standard) – This will fetch only standard fields.

Example Query: SELECT FIELDS(ALL) FROM ACCOUNT LIMIT 200

Note:  The SOQL FIELDS() function must have a LIMIT of 200. We can also use the above query in workbench but we can not export data in bulk CSV.