The RDB$CONSTRAINT_RELATIONS system table lists all tables that
participate in a given constraint. The following table provides
information on the columns of the RDB$CONSTRAINT_RELATIONS system
table.
Data
Column Name Type Summary Description
RDB$CONSTRAINT_NAME char(31) The system-wide unique name
of the constraint.
RDB$RELATION_NAME char(31) The name of a table
involved in the constraint.
RDB$FLAGS integer Flags.
RDB$CONSTRAINT_CONTEXT integer The context variable of
the table involved in the
constraint.
RDB$SECURITY_CLASS char(20) Reserved for future use.
1 – RDB$FLAGS
Represents flags for RDB$CONSTRAINT_RELATIONS system table.
Bit
Position Description
0 Reserved for future use.
1 Reserved for future use.
2 If the constraint is on the specified table.
3 If the constraint evaluates with optimization by dbkey
lookup.
4 If the constraint checks for existence.
5 If the constraint checks for uniqueness.
6 If the constraint needs to evaluate on store of
specified table row.
7 If the constraint need not evaluate on store of
specified table row.
8 If the constraint needs to evaluate on erase of
specified table row.
9 If the constraint need not evaluate on erase of
specified table row.