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:
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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|