Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


REFERENTIAL_CONSTRAINTS


The REFERENTIAL_CONSTRAINTS system view lists the referential constraints that are accessible by the current ident.

Column name
Data type
Description
CONSTRAINT
_CATALOG
VARCHAR(128)
The name of the catalog containing the referential constraint.
CONSTRAINT_SCHEMA
VARCHAR(128)
The name of the schema containing the referential constraint.
CONSTRAINT_NAME
VARCHAR(128)
The name of the referential constraint.
UNIQUE_CONSTRAINT
_CATALOG
VARCHAR(128)
The name of the catalog containing the unique constraint being referenced.
UNIQUE_CONSTRAINT
_SCHEMA
VARCHAR(128)
The name of the schema containing the unique constraint being referenced
UNIQUE_CONSTRAINT
_NAME
VARCHAR(128)
The name of the unique constraint being referenced.
MATCH_OPTION
VARCHAR(20)
One of:
NONE
PARTIAL
FULL.
UPDATE_RULE
VARCHAR(20)
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION.
DELETE_RULE
VARCHAR(20)
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX