TABLE_CONSTRAINTS View

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

For more information about referential integrity constraints, see Constraints.

See also:

REFERENTIAL_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

TABLE_CATALOG

TEXT

Name of the database of the current table

TABLE_SCHEMA

TEXT

Name of the schema of the current table

TABLE_NAME

TEXT

Name of the current table

CONSTRAINT_TYPE

TEXT

Type of the constraint

IS_DEFERRABLE

TEXT

Whether evaluation of the constraint can be deferred

INITIALLY_DEFERRED

TEXT

Whether evaluation of the constraint is deferrable and initially deferred

ENFORCED

TEXT

Whether the constraint is enforced

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.

RELY

TEXT

Whether a constraint in NOVALIDATE mode is taken into account during query rewrite. For details, see Extended Constraint Properties.

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

    • Background maintenance operations on metadata performed by Snowflake.