Chapter 3 DBMS Reference Guide

UniqConstAutoIndex

Alternate key unique Constraint is auto-indexed. This option primarily determines if a Create Index statement is required for every key statement.

Value Target database Result
Yes Automatically generates an alternate key index when generating the alternate key statement Alternate key check boxes and create alternate index cannot be selected simultaneously in the database generation or modification parameters.

If you select the alternate key check box under create index, the alternate key check box of the create table will automatically be cleared, and vice versa
No Does not generate the alternate key indexes automatically when generating the alternate keys Alternate key indexes have to be generated explicitly. Alternate key check boxes and create alternate index can be selected simultaneously

Example

In Sybase Adaptive Server Anywhere 6:

UniqConstAutoIndex = YES

 

Copyright (C) 2005. Sybase Inc. All rights reserved.