RDB$CHECK CONSTRAINTS

From InterBase
Jump to: navigation, search

Go Up to System Tables


RDB$CHECK_CONSTRAINTS stores database integrity constraint information for CHECK constraints. In addition, the table stores information for constraints implemented with NOT NULL.

RDB$CHECK_CONSTRAINTS
Column name Datatype Length Description

RDB$CONSTRAINT_NAME

CHAR

67

Subtype 2: Name of a CHECK or NOT NULL constraint

RDB$TRIGGER_NAME

CHAR

67

Subtype 2: Name of the trigger that enforces the CHECK constraint; for a NOT NULL constraint, name of the source column in RDB$RELATION_FIELDS