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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » Views » System views

 

SYSIDX system view

Each row in the SYSIDX system view defines a logical index in the database. The underlying system table for this view is ISYSIDX.

Column name Data type Description
table_id UNSIGNED INT Uniquely identifies the table to which this index applies.
index_id UNSIGNED INT A unique number identifying the index within its table.
object_id UNSIGNED BIGINT The internal ID for the index, uniquely identifying it in the database.
phys_index_id UNSIGNED INT Identifies the underlying physical index used to implement the logical index. This value is NULL for indexes on temporary tables or remote tables. Otherwise, the value corresponds to the object_id of a physical index in the SYSPHYSIDX system view.
dbspace_id SMALLINT The ID of the file in which the index is contained. This value corresponds to an entry in the SYSDBSPACE system view.
index_category TINYINT

The type of index. Values include:

  • 1   Primary key

  • 2   Foreign key

  • 3   Secondary index (includes unique constraints)

  • 4   Text indexes

"unique" TINYINT Indicates whether the index is a unique index (1), a unique constraint (2), reserved (3), a non-unique index (4), or a unique index WITH NULLS NOT DISTINCT. A unique index prevents two rows in the indexed table from having the same values in the index columns.
index_name CHAR(128) The name of the index.
not_enforced CHAR(1) For system use only.
file_id SMALLINT DEPRECATED. This column is present in SYSVIEW, but not in the underlying system table ISYSIDX. The contents of this column are the same as dbspace_id and it is provided for compatibility. Use dbspace_id instead.
 Constraints on underlying system table
 See also