REFERENTIAL_CONSTRAINTS View

This Information Schema view displays a row for each referential integrity constraint defined in the specified (or current) database.

For more information about referential integrity constraints, see Constraints.

See also:
TABLE_CONSTRAINTS View

Columns

Column Name Data Type Description
CONSTRAINT_CATALOG TEXT Database that the constraint belongs to
CONSTRAINT_SCHEMA TEXT Schema that the constraint belongs to
CONSTRAINT_NAME TEXT Name of the constraint
UNIQUE_CONSTRAINT_CATALOG TEXT Database of the unique constraint referenced by the current constraint
UNIQUE_CONSTRAINT_SCHEMA TEXT Schema of the unique constraint referenced by the current constraint
UNIQUE_CONSTRAINT_NAME TEXT Name of the unique constraint referenced by the current constraint
MATCH_OPTION TEXT Match option for the constraint
UPDATE_RULE TEXT Update Rule for the current constraint
DELETE_RULE TEXT Delete Rule for the current constraint
COMMENT TEXT Comment for this constraint
CREATED TIMESTAMP_LTZ Creation time of the constraint
LAST_ALTERED TIMESTAMP_LTZ Last altered time of the constraint

Usage Notes

  • The view only displays objects for which the current role for the session has been granted access privileges.