Creating a Sequence

You can create a sequence from the Browser or Model menu.

Note: If your model's DBMS does not support sequences and contains auto-incremented columns then, if you change to a DBMS that does support sequences, one will be created for each auto-incremented column. When changing from a DBMS that supports sequences to one that does not, sequences are converted into auto-incremented columns.

Select Model > Sequences to open the List of Sequences, and click the Add a Row tool. Then click the Properties tool to open the property sheet of the new sequence.
Alternatively, you can create a sequence by right-clicking the model (or a package), and selecting New > Sequence.
Enter an appropriate name for the sequence and then click the Physical Options or Physical Options (Common) tab and enter any DBMS-specific options.

The following example shows a sequence created in Sybase SQL Anywhere to represent the months in a year when quarterly reports are published.

For information about working with physical options, see Physical Options (PDM).
Click OK to save the sequence and return to your model.