Edit a SQL Anywhere index definition.
Prerequisites Before you can edit an index, be sure the data server that contains the index is running, and you created
and established a connection to it.
- In the Databases folder in Enterprise Explorer, under the database connection profile,
expand
the
tree for a database, expand the
Schemas folder and then the tree for the appropriate schema owner.
- Expand the Tables folder and the table that contains the index.
- Under the
Indexes folder, find the index you want to
edit.
- Right-click the
index, and choose
Edit.
- Edit the
General options.
Table 1. General options
Field
|
Description
|
Index Name
|
Enter a name for the index.
|
Unique
|
Make the index
unique. A unique index permits no two rows to have the same index value,
including NULL.
|
Clustered
|
Make the index
clustered. In clustered indexes, table data is physically stored in the order
of the keys on the index.
|
Virtual
|
Make the index
virtual, which simulates the existence of an index without actually building a
full index.
|
Dbspace
|
Specify the type of dbspace in which
to place the index. The default is SYSTEM.
|
Comments
|
Enter comments for the index.
|
- Edit the
Columns options.
Table 2. Column options
Field
|
Description
|
Filter Column by Name Pattern
|
Enter a filter expression for the columns to be
displayed in the column list. For example, * lists all columns for the
specified table.
|
Select the Columns
|
Select the columns to be used in the index. Use
Select All,
Deselect All, and
Invert Selection to change
your current selections. Use
Up and
Down to change the order
of columns listed.
|
- (Optional) View the DDL for
the index in the
DDL tab.
When you are finished editing the
index, close the
SQL Anywhere Index Editor page, and save your
results.
Sybase WorkSpace
executes the DDL to change the index and reports results to SQL Results view.