Each row in the SYSIDXCOL system view describes one column of an index described in the SYSIDX system view. The underlying system table for this view is ISYSIDXCOL.
| Column name | Data type | Description |
|---|---|---|
| table_id | UNSIGNED INT | Identifies the table to which the index applies. |
| index_id | UNSIGNED INT | Identifies the index to which the column applies. Together, table_id and index_id identify one index described in the SYSIDX system view. |
| sequence | SMALLINT | Each column in an index is assigned a unique number starting at 0. The order of these numbers determines the relative significance of the columns in the index. The most important column has sequence number 0. |
| column_id | UNSIGNED INT | Identifies which column of the table is indexed. Together, table_id and column_id identify one column described in the SYSCOLUMN system view. |
| "order" | CHAR(1) | Indicates whether the column in the index is kept in ascending(A) or descending(D) order. This value is NULL for text indexes. |
| primary_column_id | UNSIGNED INT | The ID of the primary key column that corresponds to this foreign key column. The value is NULL for non foreign key columns. |
Constraints on underlying system table See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |