CONSTRAINT_CATALOG_ID

NUMBER

Internal/system-generated identifier for the database of the constraint.

CONSTRAINT_CATALOG

VARCHAR

Database that the constraint belongs to

CONSTRAINT_SCHEMA_ID

NUMBER

Internal/system-generated identifier for the schema of the constraint.

CONSTRAINT_SCHEMA

VARCHAR

Schema that the constraint belongs to

CONSTRAINT_NAME

VARCHAR

Name of the constraint

UNIQUE_CONSTRAINT_CATALOG_ID

NUMBER

Internal/system-generated identifier for the database of the current constraint.

UNIQUE_CONSTRAINT_CATALOG

VARCHAR

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

VARCHAR

Schema of the unique constraint referenced by the current constraint.

UNIQUE_CONSTRAINT_NAME

VARCHAR

Name of the unique constraint referenced by the current constraint.

MATCH_OPTION

VARCHAR

Match option for the constraint.

UPDATE_RULE

VARCHAR

Update Rule for the current constraint.

DELETE_RULE

VARCHAR

Delete Rule for the current constraint.

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.