Skip to main content

IdKey

Primary key constraint behavior.

Synopsis

[SQL]    IdKey=n

Description

The value n may be 1 or 0:

  • 1 (true) - When a Primary Key constraint is specified, it does not also become the IDKey index in the class definition.

  • 0 (false) - A Primary Key constraint specified also becomes the IDKey index in the class definition; this generally gives better performance, but means that the Primary Key fields cannot be updated.

Examples

IdKey=1

Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Are Primary Keys Created through DDL not ID Keys setting, choose Yes (true) or No (false).

Purpose of this instance: Draft documentation
DocReleaseID: Core2018.1.11
Content loaded from:
/staging/ce/2018.1.11/doc/cache/en-us/src/
/staging/ce/2018.1.11/doc/ensemble/en-us/src/
/staging/ce/2018.1.11/doc/isp/en-us/src/
/staging/learning/zenmojo-doc/en-us/src/
FeedbackOpens in a new tab