Using DBAmp System Tables (sys_sf tables)

NOTE: The DBAmp System tables should not be used. Instead, use the DBAmp System views in the next section. This is because the views in the next section now support Where clauses.

In addition to the Salesforce.com tables, DBAmp also provides various system tables that you can access with SQL SELECT statements. These tables are read-only; you cannot update or delete them.

Also, Select statements for these tables cannot contain a WHERE clause. If you need to use a WHERE clause, create a user-defined-function that encapsulates the table. See Create DBAMP UDFS.sql for an example.

Table Name	Contents
sys_sfsession SELECT * FROMSALESFORCE…sys_sfsession	The sys_sfsession table contains information about the current Salesforce.com session. Some of the columns in this table are: SessionID – Current Session ID OrganizationID – 18 char OrgID ServerURL – URL of SForce Server
sys_sfpicklists SELECT * FROMSALESFORCE…sys_sfpicklists	The sys_sfpicklists table contains information about the picklist values for each picklist field There is one row for each per picklist value. Some of the columns in this table are: ObjectName – Name of object FieldName – Field of the above object PickListValue – A single picklist value PickListLabel – Label for the above value
sys_sfobjects SELECT * FROMSALESFORCE…sys_sfobjects	The sys_sfobjects table contains information about the Salesforce.com objects. There is one row for each object in your organization. Some of the columns in this table are: Name – Name of object Createable – Is object createable ? Deletable – Is object deletable ? URLDetail – URL Detail for this object URLNew – URL New for this object
sys_sffields SELECT * FROMSALESFORCE…sys_sffields	The sys_sffields table contains information about the Salesforce.com object fields. There is one row for each object field in your organization. Some of the columns in this table are: ObjectName – Name of object Name – Name of the field Createable – Is the field insertable ? Type – Field Type using sf terminology SQLDefinition – SQL Column definition