Column name
|
Data type
|
Description
|
---|---|---|
ID
|
INTEGER
|
Unique key identifier.
|
REL_ID
|
INTEGER
|
The relation identifier as in SYS_TABLES.
|
KEY_NAME
|
WVARCHAR
|
The name of the key.
|
KEY_UNIQUE
|
CHAR
|
Is the key unique (Yes, No).
|
KEY_NONUNIQUE_ODBC
|
SMALLINT
|
ODBC, is the key NOT unique (1, 0).
|
KEY_CLUSTERING
|
CHAR
|
Is the key a clustering key (Yes, No).
|
KEY_PRIMARY
|
CHAR
|
Is the key a primary key (Yes, No).
|
KEY_PREJOINED
|
CHAR
|
Reserved for future use.
|
KEY_SCHEMA
|
WVARCHAR
|
The owner of the key.
|
KEY_NREF
|
INTEGER
|
When creating a primary key, the server uses ALL fields of the table, even if the user specified N fields (the N fields specified by the user become the first N fields of the key). KEY_NREF = N, that is, the number of fields specified by the user.
|