Foreign Keys Schema
The Foreign Keys schema provides information about foreign keys in the server’s SQL syntax.
| Column Name | Data Type | Description |
|---|---|---|
| CONSTRAINT_CATALOG | string | |
| CONSTRAINT_SCHEMA | string | |
| CONSTRAINT_NAME | string | |
| TABLE_CATALOG | string | |
| TABLE_SCHEMA | string | |
| TABLE_NAME | string | |
| MATCH_OPTION | string | |
| UPDATE_RULE | string | |
| DELETE_RULE | string | |
| REFERENCED_TABLE_CATALOG | string | |
| REFERENCED_TABLE_SCHEMA | string | |
| REFERENCED_TABLE_NAME | string |
The following restrictions are supported:
| Restriction Name | Restriction Default | Restriction Number |
|---|---|---|
| Catalog | TABLE_CATALOG | 1 |
| Schema | TABLE_SCHEMA | 2 |
| Table | TABLE_NAME | 3 |
| Constraint Name | CONSTRAINT_NAME | 4 |