:

Usage

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

Createable

Calculated

Updateable

Filterable

DefaultedOnCreate

Nillable (according to the Salesforce API)

Sortable 

Unique

a Restricted Picklist

an ExternalId

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

The _Fields view created by the stored procedure SF_CreateSysViews also contains that information, so this stored procedure is best used when you have more than 2000 fields on Salesforce. In those 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’