Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


REFER_CONSTRAINTS


Records referential constraints in the database.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier for the table.

CONSTRAINT_SYSID

INTEGER

System identifier for the referential constraint.

UNIQUE_TABLE_SYSID

INTEGER

System identifier for the table that is referenced in the foreign key.

UNIQUE_CONST_SYSID

INTEGER

System identifier for the constraint that is (implicitly) referenced in the foreign key.

MATCH_OPTION

CHAR(20)

One of:
"NONE"
"PARTIAL"
"FULL".

UPDATE_RULE

CHAR(20)

One of:
"CASCADE"
"SET NULL"
"SET DEFAULT"
"NO ACTION"
"RESTRICT".

DELETE_RULE

CHAR(20)

One of:
"CASCADE"
"SET NULL"
"SET DEFAULT"
"NO ACTION"
"RESTRICT".

Primary key: TABLE_SYSID, CONSTRAINT_SYSID

Secondary index: UNIQUE_TABLE_SYSID, UNIQUE_CONST_SYSID



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