Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


KEY_COLUMN_USAGE


Records columns in an index or in a primary, unique or foreign key.

Column name
Data type
Description

TABLE_SYSID

INTEGER

System identifier for the table.

CONSTRAINT_SYSID

INTEGER

System identifier for the table column.

ORDINAL_POSITION

INTEGER

The ordinal position of the column in the table.
The first column in the table is number 1.

COLUMN_NAME

VARCHAR(128)

The name of the table column.

KEY_TYPE

CHAR(20)

One of:
"PRIMARY_KEY"
"UNIQUE"
"FOREIGN KEY"
"INDEX"
"INTERNAL_KEY".

IS_UNIQUE

CHAR(3)

One of:
"NO" = unique values are permitted in the column
"YES" = the column is constrained to contain only unique values.

IS_ASCENDING

CHAR(3)

One of:
"NO" = the column is indexed in descending value order
"YES" = the column is indexed in ascending value order.

Primary key: TABLE_SYSID, CONSTRAINT_SYSID, ORDINAL_POSITION

Unique constraint: CONSTRAINT_SYSID, COLUMN_NAME



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