Sequences

Creating sequences

1. Go to Databases
2. Select the database in which you want to create a sequence.
3. Select the schema in which you want to create a sequence.
4. Go to DB Objects > Sequences.
5. Click Create sequence.
6. Type a name for sequence. The name can be up to 128 characters long and it must begin with a letter or underscore and cannot contain embedded spaces. The name must be unique. If the name contains special characters, enclose it in double quotation marks.
7. Specify the starting integer value for the sequence.
8. Specify the minimum value.
9. Specify the maximum value.
10. Specify the increment by value.
11. Specify whether you want the sequence to restart when it reaches its last value by checking the Cycle box. The default is No cycle, which means that the sequence stops when it reaches its last value.
12. Click Create.

You can select Assign owner, Rename, Alter and Drop options from the overflow menu.