The SYS_REFERENTIAL_CONSTRAINTS table contains additional information about foreign keys. It has the following columns:
Column Name |
Data Type |
Description |
|---|---|---|
| CONSTRAINT_CATALOG | VARCHAR(128) | Top-level container for constraints. Not used in dotConnect for BigCommerce. Always NULL. |
| CONSTRAINT_SCHEMA | VARCHAR(128) | Second-level container for constraints. Not used in dotConnect for BigCommerce. Always NULL. |
| CONSTRAINT_NAME | VARCHAR(128) | The name of the foreign key constraint. |
| UNIQUE_CONSTRAINT_CATALOG | VARCHAR(128) | Top-level container for referenced constraints. Not used in dotConnect for BigCommerce. Always NULL. |
| UNIQUE_CONSTRAINT_SCHEMA | VARCHAR(128) | Second-level container for referenced constraints. Not used in dotConnect for BigCommerce. Always NULL. |
| UNIQUE_CONSTRAINT_NAME | VARCHAR(128) | The name of the referenced constraint. |
| MATCH_OPTION | VARCHAR(7) | Always "NONE". Not used in dotConnect for BigCommerce. |
| UPDATE_RULE | VARCHAR(9) | Always "NO ACTION". Not used in dotConnect for BigCommerce. |
| DELETE_RULE | VARCHAR(9) |
Action to perform when SQL statement violates this referential constraint. Can have one of the following values:
|
| OBJECT | VARCHAR(128) | The name of the table, this foreign key belongs to. |
| FIELD | VARCHAR(128) | The foreign key column. |
| RELATED_OBJECT | VARCHAR(128) | The name of the table, this foreign key references. |
| RELATED_FIELD | VARCHAR(128) | The name of the field, this foreign key references. Always "ID" |