Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSIDX system view Next Page

SYSIDXCOL system view


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.

Columns
Column name Column type Column constraint
table_id UNSIGNED INT NOT NULL
index_id UNSIGNED INT NOT NULL
sequence SMALLINT NOT NULL
column_id UNSIGNED INT NOT NULL
"order" CHAR(1) NOT NULL
primary_column_idUNSIGNED INT

table_id    Identifies the table to which the index applies.

index_id    Identifies the index to which the column applies. Together, table_id and index_id identify one index described in the SYSIDX system view.

sequence    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    Identifies which column of the table is indexed. Together, table_id and column_id identify one column described in the SYSCOLUMN system view.

order (A/D)    Indicates whether the column in the index is kept in ascending(A) or descending(D) order.

primary_column_id    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

PRIMARY KEY (table_id, index_id, column_id)

FOREIGN KEY (table_id, index_id) references SYS.ISYSIDX (table_id, index_id)

FOREIGN KEY (table_id, column_id) references SYS.ISYSTABCOL (table_id, column_id)

See also