SF_SysObjectsTable


SF_SysObjectsTable


Usage

SF_SysSFObjectsTable generates a table named Sys_SFObjects, which contains a row for each object, with bit columns denoting whether each object is

  • Createable
  • Deletable
  • Updateable
  • Queryable
  • Replicateable

or whether it is a custom field.

The _Object 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_SFObjects table allows this.

Syntax

EXEC SF_SysSFObjectsTable ‘linked_server’

where linked_server is your linked server name.

Example

EXEC SF_SysSFObjectsTable 'Salesforce'