Index property view
Description
Add as many single- or multivalued indexes to a database table
as you need.
If your back-end DBMS requires additional information to define
an index, additional options display. For example, in Adaptive Server
Enterprise, you must specify whether the index is clustered. SQL
Anywhere only requires the information described here.
Options
Table
The name of the table.
Owner
The owner of the table.
Index
Enter a name for the index you are creating.
Columns
Select the names of the columns in the table on which you
want to create the index. The selected column names display in the
Order box. To deselect a selected column, clear its check box..
Unique
Select the type of index you want. The default is Unique (the
indexed columns must contain unique values). To allow duplicates, clear
the check box.
Ascending
Select if you want the index in Ascending order.