RDB$RELATION CONSTRAINTS

From InterBase
Jump to: navigation, search

Go Up to System Tables


RDB$RELATION_CONSTRAINTS stores information about integrity constraints for tables.

RDB$RELATION_CONSTRAINTS
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:

  • 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