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

SQL Anywhere 11.0.1 » Context-Sensitive Help » SQL Anywhere plug-in help

 

Indexes folder

The Indexes folder provides a way for you to view all the indexes in a database. Once you are connected to a database, click the Indexes folder to display all the indexes.

The following information is displayed for each entry, and can be used to sort the list:

  • Index name   Shows the name of the index.

  • Object name   Shows the name of the object with which the index is associated.

  • Object owner   Shows the name of the owner of the object with which the index is associated.

  • Index type   Shows the type of index. The type can be foreign key index, primary key index, unique constraint index, or index.

  • Unique   Shows whether values in the index must be unique. The unique value is set when you create a new index.

  • Columns   Shows all the columns in the index.

See also