Chapter 3 DBMS Reference Guide
Foreign key is auto-indexed. This option determines whether or not to generate a Create Index
statement for every Foreign key statement.
| Value | DBMS | Result |
|---|---|---|
| Yes | Automatically generates a foreign key index when generating the primary, alternate, or foreign key statements | The Foreign key check box in the Index Filter group of check boxes, and the Create Foreign Keys check box, cannot be selected simultaneously in the Keys and Indexes tab of the Database Generation box |
| No | Does not generate the foreign key indexes automatically when generating foreign keys | Foreign key indexes have to be generated explicitly. Foreign key check boxes of both create table and create index can be selected simultaneously |
FKAutoIndex = YES
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |