Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$RELATION_CONSTRAINTS
Firebird Firebird Prev: RDB$RELATIONSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$RELATION_FIELDS

RDB$RELATION_CONSTRAINTS

RDB$RELATION_CONSTRAINTS stores the definitions of all table-level constraints: primary, unique, foreign key, CHECK, NOT NULL constraints.

Column Name Data Type Description
RDB$CONSTRAINT_NAME CHAR(31) The name of the table-level constraint defined by the user, or otherwise automatically generated by the system
RDB$CONSTRAINT_TYPE CHAR(11) The name of the constraint type: PRIMARY KEY, UNIQUE, FOREIGN KEY, CHECK or NOT NULL
RDB$RELATION_NAME CHAR(31) The name of the table this constraint applies to
RDB$DEFERRABLE CHAR(3) Currently NO in all cases: Firebird does not yet support deferrable constraints
RDB$INITIALLY_DEFERRED CHAR(3) Currently NO in all cases
RDB$INDEX_NAME CHAR(31) The name of the index that supports this constraint. For a CHECK or a NOT NULL constraint, it is NULL.

Prev: RDB$RELATIONSFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$RELATION_FIELDS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$RELATION_CONSTRAINTS