REFERENTIAL CONSTRAINTS

From InterBase

Go Up to System Views


REFERENTIAL_CONSTRAINTS identifies all referential constraints defined in a database.

REFERENTIAL_CONSTRAINTS
Column name Data type Length Description

CONSTRAINT_NAME

CHAR

67

Unique name for the constraint; nullable

UNIQUE_CONSTRAINT_NAME

CHAR

67

Name of the UNIQUE or PRIMARY KEY constraint corresponding to the specified referenced column list; nullable

MATCH_OPTION

CHAR

7

Reserved for future use; always set to FULL; nullable

UPDATE_RULE

CHAR

11

Reserved for future use; always set to RESTRICT; nullable

DELETE_RULE

CHAR

11

Reserved for future use; always set to RESTRICT; nullable

Advance To: