Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


KEY_COLUMN_USAGE


The KEY_COLUMN_USAGE system view lists the table columns that are constrained as keys and owned by the current ident.

Column name
Data type
Description
CONSTRAINT_CATALOG
VARCHAR(128)
The name of the catalog containing the table constraint.
CONSTRAINT_SCHEMA
VARCHAR(128)
The name of the schema containing the table or view.
CONSTRAINT_NAME
VARCHAR(128)
The name of the table constraint.
TABLE_CATALOG
VARCHAR(128)
The name of the catalog containing the table or view.
TABLE_SCHEMA
VARCHAR(128)
The name of the schema containing the table or view.
TABLE_NAME
VARCHAR(128)
The name of the table or view.
COLUMN_NAME
VARCHAR(128)
The name of the column.
ORDINAL_POSITION
INTEGER
The ordinal position of the column within the key.



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