For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.
Property | Description |
---|---|
Name | Specifies a name for the object. |
Label | Specifies a label that is displayed in visual diagrams. |
Data type | Specifies a data type for the sequence value. |
Property | Description |
---|---|
Start value | Specifies a value for the START WITH clause. |
Increment | Specifies a value for the INCREMENT BY clause. |
Minimum | Specifies a value for the MINVALUE clause. |
Maximum | Specifies a value for the MAXVALUE clause. |
Cycle | Specifies the CYCLE option. Specifies whether the sequence should continue to generate values after reaching either its maximum or minimum value. |
Cache | Specifies the CACHE option. Specifies whether
to keep some preallocated values in memory for faster access. This
is a performance and tuning option. If you select this check box, specify the maximum number of sequence values that are preallocated and kept in memory. The minimum value is 2. The default value is 20. |
Order | Specifies the ORDER option. Specifies whether the sequence numbers must be generated in order of request. |