SF_SysSFFieldsTable


SF_SysSFFieldsTable


Usage

SF_SysSFFieldsTable generates a table named Sys_SFFields that contains a row for each field, with bit columns denoting whether each field is

  • Creatable
  • Calculated
  • Updatable
  • Filterable
  • DefaultedOnCreate
  • Nillable (according to the Salesforce API)
  • Sortable
  • Unique
  • a Restricted Picklist
  • an ExternalId

It also returns the Salesforce type and Salesforce label, the object the field belongs to, and a RelationshipName when applicable.

The _Fields view created by the stored procedure SF_CreateSysViews also contains this information. You should use this stored procedure when you have more than 2000 fields on Salesforce. In these situations, Salesforce does not allow all objects to be queried from the EntityDefinition table; the Sys_SFFields table allows this.

Syntax

EXEC SF_SysSFFieldsTable 'linked_server'

where linked_server is your linked server name.

Example

EXEC SF_SysSFFieldsTable 'SALESFORCE'