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.