Each row in the sysixcol system table describes one column of an index listed in sysindex.
Column name | Column type | Description |
---|---|---|
column_id | UNSIGNED INT | A unique identifier for the column being indexed. |
index_id | UNSIGNED INT | A unique identifier for the index that this index-column belongs to. |
order | CHAR(1) | Indicates whether the column in the index is kept in ascending (A) or descending (D) order. |
sequence | SMALLINT | The order of the column in the index. |
table_id | UNSIGNED INT | A unique identifier for the table to which the index applies. |
PRIMARY KEY( table_id, index_id, sequence )
FOREIGN KEY( table_id, index_id ) REFERENCES sysindex( table_id, object_id )
FOREIGN KEY( table_id, column_id ) REFERENCES syscolumn( table_id, object_id )
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |