Schema:
ACCOUNT_USAGE

TABLE_CONSTRAINTS View

This Account Usage view displays a row for each referential integrity constraint defined for the tables in the account.

For more information about referential integrity constraints, see Constraints.

See also:
REFERENTIAL_CONSTRAINTS View

Columns

Column Name Data Type Description
CONSTRAINT_ID NUMBER Internal/system-generated identifier for the constraint.
CONSTRAINT_NAME TEXT Name of the constraint.
CONSTRAINT_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema of the constraint.
CONSTRAINT_SCHEMA TEXT Schema that the constraint belongs to.
CONSTRAINT_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the constraint.
CONSTRAINT_CATALOG TEXT Database that the constraint belongs to.
TABLE_ID NUMBER Internal/system-generated identifier for the table that the constraint belongs to.
TABLE_NAME TEXT Name of the current table.
TABLE_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema of the current table.
TABLE_SCHEMA TEXT Name of the schema for the current table.
TABLE_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the current table.
TABLE_CATALOG TEXT Name of the database for the current table.
CONSTRAINT_TYPE TEXT Type of the constraint (PRIMARY KEY, UNIQUE KEY, or FOREIGN KEY).
IS_DEFERRABLE TEXT Whether evaluation of the constraint can be deferred; by default, always N.
INITIALLY_DEFERRED TEXT Whether evaluation of the constraint is deferrable and initially deferred; by default, always Y.
ENFORCED TEXT Whether the constraint is enforced; by default, always N.
COMMENT TEXT Comment for the constraint.
CREATED TIMESTAMP_LTZ Date and time when the constraint was created.
LAST_ALTERED TIMESTAMP_LTZ Date and time when the constraint was last altered.
DELETED TIMESTAMP_LTZ Date and time when the constraint was dropped.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).
  • The view only displays objects for which the current role for the session has been granted access privileges.