CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Referential_Constraints View
 
Referential_Constraints View
Describes the referential constraints.
This view is part of the ANSI SQL-2 standard Information Schema.
Column
Data Type
N
Description
RECORD_NUMBER
integer
n
unique identifier for this record of metadata
CONSTRAINT_CATALOG
identifier
n
constraint catalog
CONSTRAINT_SCHEMA
identifier
n
constraint schema
CONSTRAINT_NAME
identifier
n
constraint name
UNIQUE_CONSTRAINT_CATALOG
identifier
n
unique constraint catalog
UNIQUE_CONSTRAINT_SCHEMA
identifier
n
unique constraint schema
UNIQUE_CONSTRAINT_NAME
identifier
n
unique constraint name
MATCH_OPTION
enumeration
n
match option: NONE or PARTIAL or FULL
UPDATE_RULE
enumeration
n
update rule: NO ACTION or CASCADE or SET NULL or SET DEFAULT
DELETE_RULE
enumeration
n
delete rule: NO ACTION or CASCADE or SET NULL or SET DEFAULT
IS_CLUSTERING
yes_no
n
Y if the referential constraint is implied by a table cluster