A row of SYSTEM.INDEXKEY identifies a key column defined in an index. This information is for documentation and is not used in internal processing.
View SYSCA.INDEXKEY is defined on SYSTEM.INDEXKEY.
Note: For more information, see SYSCA Objects.
|
Column name |
Column description |
Data type |
Null specifi- cation |
|---|---|---|---|
|
NAME |
Index name. |
CHAR(18) |
NOT NULL |
|
SCHEMA |
Schema-name qualifier for the indexed table. |
CHAR(18) |
NOT NULL |
|
TABLE |
Name of the indexed table. |
CHAR(18) |
NOT NULL |
|
SEQUENCE |
Internal index key sequence number. |
SMALLINT |
NOT NULL |
|
NUMBER |
Column number of the key column. |
SMALLINT |
NOT NULL |
|
COLUMN |
Column name of the key column. |
|
|
|
SORTORDER |
Index key sort order:
|
CHAR(1) |
NOT NULL |
|
FILLER |
Reserved for future use. |
BINARY(37) |
NOT NULL |
|
Copyright © 2014 CA.
All rights reserved.
|
|