- Schema:
TABLE_
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
This Organization Usage view displays a row for each table constraint that is defined for the tables in an account.
This view returns information about the following constraint types:
- PRIMARY KEY
- FOREIGN KEY
- UNIQUE
For general information about constraints, see Constraints.
- See also:
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column Name | Data Type | Description |
|---|---|---|
| CONSTRAINT_ID | NUMBER | Internal/system-generated identifier for the constraint. |
| CONSTRAINT_NAME | VARCHAR | Name of the constraint. |
| CONSTRAINT_SCHEMA_ID | NUMBER | Internal/system-generated identifier for the schema of the constraint. |
| CONSTRAINT_SCHEMA | VARCHAR | Schema that the constraint belongs to. |
| CONSTRAINT_CATALOG_ID | NUMBER | Internal/system-generated identifier for the database of the constraint. |
| CONSTRAINT_CATALOG | VARCHAR | Database that the constraint belongs to. |
| TABLE_ID | NUMBER | Internal/system-generated identifier for the table that the constraint belongs to. |
| TABLE_NAME | VARCHAR | Name of the current table. |
| TABLE_SCHEMA_ID | NUMBER | Internal/system-generated identifier for the schema of the current table. |
| TABLE_SCHEMA | VARCHAR | 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 | VARCHAR | Name of the database for the current table. |
| CONSTRAINT_TYPE | VARCHAR | Type of the constraint (PRIMARY KEY, UNIQUE KEY, or FOREIGN KEY). |
| IS_DEFERRABLE | VARCHAR | Whether evaluation of the constraint can be deferred; by default, always N. |
| INITIALLY_DEFERRED | VARCHAR | Whether evaluation of the constraint is deferrable and initially deferred; by default, always Y. |
| ENFORCED | VARCHAR | Whether the constraint is enforced; by default, always N. |
| COMMENT | VARCHAR | 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 | VARCHAR | 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 24 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.