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.

Back to top