dotConnect for Salesforce Documentation
In This Topic
    SYS_KEY_COLUMN_USAGE
    In This Topic

    The SYS_KEY_COLUMN_USAGE table contains information to match columns with constraints. It has the following columns:

    Column Name

    Data Type

    Description

    CONSTRAINT_CATALOG VARCHAR(128) Top-level container for constraints. Not used in dotConnect for Salesforce. Always NULL.
    CONSTRAINT_SCHEMA VARCHAR(128) Second-level container for constraints. Not used in dotConnect for Salesforce. Always NULL.
    CONSTRAINT_NAME VARCHAR(128) The name of the constraint.
    TABLE_CATALOG VARCHAR(128) Top-level container for tables. Not used in dotConnect for Salesforce. Always NULL.
    TABLE_SCHEMA VARCHAR(128) Second-level container for tables. Not used in dotConnect for Salesforce. Always NULL.
    TABLE_NAME VARCHAR(128) The name of the Salesforce.com or Database.com object which the field belongs to.
    COLUMN_NAME VARCHAR(128) The name of a Salesforce.com or Database.com object field.
    ORDINAL_POSITION INT The position of the field in the key. Always 1, because the primary keys in Salesforce.com and Database.com always consists of the single ID field.