Schema:
ACCOUNT_USAGE

REFERENTIAL_CONSTRAINTS View

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

For more information about referential integrity constraints, see Constraints.

See also:
TABLE_CONSTRAINTS View

Columns

Column Name Data Type Description
CONSTRAINT_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the constraint.
CONSTRAINT_CATALOG TEXT Database that the constraint belongs to
CONSTRAINT_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema of the constraint.
CONSTRAINT_SCHEMA TEXT Schema that the constraint belongs to
CONSTRAINT_NAME TEXT Name of the constraint
UNIQUE_CONSTRAINT_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the current constraint.
UNIQUE_CONSTRAINT_CATALOG TEXT Database of the unique constraint referenced by the current constraint.
UNIQUE_CONSTRAINT_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema of the 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 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.