Schema:: ACCOUNT_USAGE

TABLE_CONSTRAINTS view¶

This Account Usage view displays a row for each table constraint that is defined for the tables in the account.

This view returns information about the following constraint types:

PRIMARY KEY
FOREIGN KEY
UNIQUE

For general information about 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 the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.
DELETED	TIMESTAMP_LTZ	Date and time when the constraint was dropped.
RELY	TEXT	Whether a constraint in NOVALIDATE mode is taken into account during query rewrite. For details, see Constraint properties.

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.
The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.
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.