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