RDB$RELATION CONSTRAINTS

Go Up to System Tables

RDB$RELATION_CONSTRAINTS stores information about integrity constraints for tables.

RDB$RELATION_CONSTRAINTS

Column name	Datatype	Length	Description
RDB$CONSTRAINT_NAME	CHAR	67	Name of a table constraint
RDB$CONSTRAINT_TYPE	CHAR	11	Type of table constraint Constraint types are:
			PRIMARY KEY UNIQUE FOREIGN KEY	CHECK NOT NULL
RDB$RELATION_NAME	CHAR	67	Name of the table for which the constraint is defined
RDB$DEFERRABLE	CHAR	3	Reserved for later use; currently defaults to No
RDB$INITIALLY_DEFERRED	CHAR	3	Reserved for later use; currently defaults to No
RDB$INDEX_NAME	CHAR	67	Name of the index used by UNIQUE, PRIMARY KEY, or FOREIGN KEY constraints