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 that information, so this stored procedure is best used when you have more than 2000 objects on Salesforce. In those situations, Salesforce does not allow all objects to be queried from the EntityDefinition table; the _Object view allows this.
Syntax
EXEC SF_SysSFObjectsTable ‘linked_server’
where linked_server is your linked server name.
Example
EXEC SF_SysSFObjectsTable 'Salesforce'