Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


TABLE_CONSTRAINTS


Records table constraints in the database.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier of the table.

CONSTRAINT_TYPE

CHAR(20)

One of:
"PRIMARY KEY"
"UNIQUE"
"FOREIGN KEY"
"INDEX"
"INDEX UNIQUE"
"INTERNAL KEY"
"CHECK".

CONSTRAINT_SYSID

INTEGER

System identifier of the constraint.

CONSTRAINT_KEYCOLS

INTEGER

Number of key columns in the constraint.

CONSTRAINT_KEYLEN

INTEGER

Record length for key columns in the constraint.

CONSTRAINT_RECCOLS

INTEGER

Number of columns in constraint.

CONSTRAINT_RECLEN

INTEGER

Record length for constraint.

CONSTRAINT_CARD

BIGINT

Number of records in constraint.

DATABANK_SYSID

INTEGER

System identifier of the databank in which the table is stored.

IS_CONSISTENT

CHAR(3)

One of:
"NO" = The index may be inconsistent and should be used for index lookup only
"YES" = The index may be used for index lookup only.

IS_DEFERRABLE

CHAR(3)

One of:
"NO" = The constraint is not deferrable
"YES" = The constraint is deferrable.

INITIALLY_DEFERRED

CHAR(3)

One of:
"NO" = The constraint is immediate
"YES" = The constraint is not immediate.

Primary key: TABLE_SYSID, CONSTRAINT_TYPE, CONSTRAINT_SYSID

Unique constraint: CONSTRAINT_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