Chapter 3 DBMS Reference Guide
Primary key is auto-indexed. This option primarily determines whether to generate a Create Index
statement for every Primary key statement.
| Value | Target database | Result |
|---|---|---|
| Yes | Automatically generates a primary key index when generating the primary key statement | Primary key check boxes and create index cannot be selected simultaneously in the database generation or modification parameters.
If you select the primary key check box under create index, the primary key check box of the create table will automatically be cleared, and vice versa |
| No | Does not generate the primary key indexes automatically when generating the primary keys | Primary key indexes have to be generated explicitly. Primary key check boxes and create index can be selected simultaneously |
In Sybase Adaptive Server Anywhere 6:
PkAutoIndex = YES
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |