Chapter 3 DBMS Reference Guide


FKAutoIndex

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

Example

FKAutoIndex = YES

 


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