dotConnect for MongoDB Documentation
On this page
    SYS_REFERENTIAL_CONSTRAINTS
    On this page

    The SYS_REFERENTIAL_CONSTRAINTS table is meant for the details of foreign keys. MongoDB has no foreign keys, so the table is always empty; it is kept for the compatibility of the information schema. It has the following columns:

    Column Name

    Data Type

    Description

    CONSTRAINT_CATALOG VARCHAR Top-level container for constraints.
    CONSTRAINT_SCHEMA VARCHAR Second-level container for constraints.
    CONSTRAINT_NAME VARCHAR The name of the foreign key constraint.
    UNIQUE_CONSTRAINT_CATALOG VARCHAR Top-level container for referenced constraints.
    UNIQUE_CONSTRAINT_SCHEMA VARCHAR Second-level container for referenced constraints.
    UNIQUE_CONSTRAINT_NAME VARCHAR The name of the referenced constraint.
    MATCH_OPTION VARCHAR The match option of the constraint.
    UPDATE_RULE VARCHAR Action to perform when an UPDATE violates the constraint.
    DELETE_RULE VARCHAR Action to perform when a DELETE violates the constraint.
    OBJECT_CATALOG VARCHAR Top-level container of the table this foreign key belongs to.
    OBJECT_SCHEMA VARCHAR Second-level container of the table this foreign key belongs to.
    OBJECT VARCHAR The name of the table this foreign key belongs to.
    FIELD VARCHAR The foreign key column.
    RELATED_OBJECT_CATALOG VARCHAR Top-level container of the table this foreign key references.
    RELATED_OBJECT_SCHEMA VARCHAR Second-level container of the table this foreign key references.
    RELATED_OBJECT VARCHAR The name of the table this foreign key references.
    RELATED_FIELD VARCHAR The name of the column this foreign key references.