dotConnect for Google BigQuery Documentation
On this page
    SYS_REFERENTIAL_CONSTRAINTS
    On this page

    The SYS_REFERENTIAL_CONSTRAINTS table is intended for additional information about foreign keys. dotConnect for Google BigQuery doesn't return foreign keys, so this table is always empty. 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 foreign key constraint.
    UNIQUE_CONSTRAINT_CATALOG VARCHAR(128) The Google Cloud project that contains the referenced constraint.
    UNIQUE_CONSTRAINT_SCHEMA VARCHAR(128) The dataset that contains the referenced constraint.
    UNIQUE_CONSTRAINT_NAME VARCHAR(128) The name of the referenced constraint.
    MATCH_OPTION VARCHAR(7) The match option of the foreign key.
    UPDATE_RULE VARCHAR(9) The update rule of the foreign key.
    DELETE_RULE VARCHAR(9) The delete rule of the foreign key.
    OBJECT_CATALOG VARCHAR(128) The Google Cloud project that contains the table this foreign key belongs to.
    OBJECT_SCHEMA VARCHAR(128) The dataset that contains the table this foreign key belongs to.
    OBJECT VARCHAR(128) The name of the table this foreign key belongs to.
    FIELD VARCHAR(128) The foreign key column.
    RELATED_OBJECT_CATALOG VARCHAR(128) The Google Cloud project that contains the referenced table.
    RELATED_OBJECT_SCHEMA VARCHAR(128) The dataset that contains the referenced table.
    RELATED_OBJECT VARCHAR(128) The name of the table this foreign key references.
    RELATED_FIELD VARCHAR(128) The name of the column this foreign key references.