602SQL Documentation Index  

Sequence Designer

A special designer allows the creation and modification to sequences in the 602SQL Client. The designer itself is very simple, it contains only a few fields, whose meaning can be found on the sequence definition.

You can also create, modify or delete sequences using the CREATE SEQUENCE, ALTER SEQUENCE and DROP SEQUENCE SQL statements.

The sequence design can be checked at anytime using the Design / Validate command. The SQL source code generated from the design can be displayed using the Design / Show SQL command.

You can reset the sequence (set the next value to the initial value) with Object / Restart. You cannot change the next value from the designer (only with the ALTER SEQUENCE RESTART WITH new_value command).