|
Each row in the sysixcol system table describes one column of an index listed in sysindex.
| Column name | Description | Type | Data constraint | Integrity constraints |
|---|---|---|---|---|
|
column_id |
A unique identifier for the column being indexed. |
UNSIGNED INT |
NOT NULL |
Foreign key references syscolumn. |
|
index_id |
A unique identifier for the index that this index-column belongs to. |
UNSIGNED INT |
NOT NULL |
Primary key. Foreign key references sysindex. |
|
order |
Indicates whether the column in the index is kept in ascending (A) or descending(D) order. |
CHAR(1) |
NOT NULL | |
|
sequence |
The order of the column in the index. |
SMALLINT |
NOT NULL |
Primary key. |
|
table_id |
A unique identifier for the table to which the index applies. |
UNSIGNED INT |
NOT NULL |
Primary key. |