dotConnect for QuickBooks Online Documentation
In This Topic
    SYS_TABLE_CONSTRAINTS
    In This Topic

    The SYS_TABLE_CONSTRAINTS table lists constraints and specifies their types and tables they belong to. It has the following columns:

    Column Name

    Data Type

    Description

    CONSTRAINT_CATALOG VARCHAR(128) Top-level container for constraints. Not used in dotConnect for QuickBooks Online. Always NULL.
    CONSTRAINT_SCHEMA VARCHAR(128) Second-level container for constraints. Not used in dotConnect for QuickBooks Online. 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 QuickBooks Online. Always NULL.
    TABLE_SCHEMA VARCHAR(128) Second-level container for tables. Not used in dotConnect for QuickBooks Online. Always NULL.
    TABLE_NAME VARCHAR(128) The name of the QuickBooks Online object which the constraint belongs to.
    CONSTRAINT_TYPE VARCHAR(11) Type of a constraint. Can be "PRIMARY KEY" or "FOREIGN KEY".
    IS_DEFERRABLE VARCHAR(3) Not used in dotConnect for QuickBooks Online. Always "NO".
    INITIALLY_DEFERRED VARCHAR(3) Not used in dotConnect for QuickBooks Online. Always "NO".