Click Sequence from diagram toolbar and drag it on the diagram pane.
![]() |
| Create sequence |
Type the name for sequence when it is created.
![]() |
| 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 |
| NOTE: | Generate sequence is only supported in DB2 and Oracle. |
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 |
When using Object-Relational Mapping feature, the primary key value will be inserted automatically from the sequence.