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 |
Date and time the object was last altered. See Usage Notes. |
Usage notes¶
The view only displays objects for which the current role for the session has been granted access privileges.
The LAST_ALTERED column is updated when the following operations are performed on an object:
DDL operations.
DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
Background maintenance operations on metadata performed by Snowflake.