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 FreshBooks. Always NULL. |
| CONSTRAINT_SCHEMA | VARCHAR(128) | Second-level container for constraints. Not used in dotConnect for FreshBooks. 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 FreshBooks. Always NULL. |
| TABLE_SCHEMA | VARCHAR(128) | Second-level container for tables. Not used in dotConnect for FreshBooks. Always NULL. |
| TABLE_NAME | VARCHAR(128) | The name of the FreshBooks 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 FreshBooks. Always "NO". |
| INITIALLY_DEFERRED | VARCHAR(3) | Not used in dotConnect for FreshBooks. Always "NO". |