dotConnect for Google BigQuery Documentation
The SYS_TABLE_CONSTRAINTS table lists constraints and specifies their types and tables they belong to. dotConnect for Google BigQuery returns primary keys only. It has the following columns:
Column Name |
Data Type |
Description |
|---|---|---|
| CONSTRAINT_CATALOG | VARCHAR(128) | The Google Cloud project that contains the constraint. |
| CONSTRAINT_SCHEMA | VARCHAR(128) | The dataset that contains the constraint. |
| CONSTRAINT_NAME | VARCHAR(128) | The name of the constraint. dotConnect for Google BigQuery names primary keys as PK_<dataset>_<table>. |
| TABLE_CATALOG | VARCHAR(128) | The Google Cloud project that contains the table. |
| TABLE_SCHEMA | VARCHAR(128) | The dataset that contains the table. |
| TABLE_NAME | VARCHAR(128) | The name of the table which the constraint belongs to. |
| CONSTRAINT_TYPE | VARCHAR(11) | The type of a constraint. Always "PRIMARY KEY". |
| IS_DEFERRABLE | VARCHAR(3) | Not used in dotConnect for Google BigQuery. Always "NO". |
| INITIALLY_DEFERRED | VARCHAR(3) | Not used in dotConnect for Google BigQuery. Always "NO". |