How to Define Sequence Numbers for Domains (Oracle only)

Previous Next

See Also

By default, the sequence numbers that are used for primary keys start with one, and increment by one. In an Oracle environment, however, you may change these settings.

See Oracle's SQL Language Reference Manual for more information.

To define a sequence:

1. With the required Domains window open, click the Related List button on the toolbar and choose Sequence Definitions of this Domain.

The Sequence Definitions of This Domain window appears.

2. For each sequence that you want to define, specify the increment, the starting value, the maximum and minimum values, and the cycle, cache, and order values.
3. Save your changes.