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'