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". |