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:
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.