• Usage
• Syntax
• Example

Usage

SF_SysSFPicklistsTable generates a table named Sys_SFPicklists that contains a row for each picklist field value, with bit columns denoting whether each value is Active or Default.

It also returns

• the name of the object and field the value belongs to
• the API value
• the UI label for the value

Syntax

EXEC SF_SysSFPicklistsTable 'linked_server'

where linked_server is your linked server name.

Example

EXEC SF_SysSFPicklistsTable 'SALESFORCE'