RDB$RELATION CONSTRAINTS
From InterBase
Go Up to System Tables
RDB$RELATION_CONSTRAINTS stores information about integrity constraints for tables.
Column name | Data type | Length |
Description | |
---|---|---|---|---|
RDB$CONSTRAINT_NAME |
CHAR |
67 |
Name of a table constraint | |
RDB$CONSTRAINT_TYPE |
CHAR |
11 |
Type of table constraint Constraint types are: | |
|
| |||
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 |