Drawing sequence

Creating sequence

Click Sequence from diagram toolbar and drag it on the diagram pane.

Create sequence
Create sequence

Type the name for sequence when it is created.

Rename sequence
Rename sequence

Right click on the sequence and select Open Specification... from the pop-up menu. In Sequence Specification dialog box, specify sequence attributes.

Specify sequence attributes
Specify sequence attributes
NOTE: Generate sequence is only supported in DB2 and Oracle.

Select sequence for entity

After creating an entity and a primary key column, right click on the primary key column and select Open Specification... from the pop-up menu.

In Column Specification dialog, select sequence for ID Generator, and select the sequence name for Key.

Select sequence for entity
Select sequence for entity

When using Object-Relational Mapping feature, the primary key value will be inserted automatically from the sequence.