SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Unique Constraint property sheet
The General tab of the Unique Constraint property sheet has the following components:
Name Shows the name of the unique constraint. You can change the name of the unique constraint in the adjacent field.
Type Shows the type of object.
Table Shows the table to which the unique constraint belongs.
Clustered Shows whether the table containing the unique constraint has a clustered index. Clustered indexes are supported for Adaptive Server Anywhere databases that are version 8.0.2 and higher.
Clustered indexes in Adaptive Server Anywhere store the table rows in approximately the same order as they appear in the corresponding index. Using a clustered index can lead to performance benefits by reducing the number of times each page needs to be read into memory. Only one index on a table can be a clustered index.
For more information about clustered indexes, see CREATE INDEX statement.
Set Clustered Index Now Opens the Set Clustered Index dialog where you can specify that an index on the table containing the unique constraint is a clustered index.
Index type Shows the type of index the table has.