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'