DB2 Create Sequence
The DB2 Create Sequence Tool allows users to visually create sequences.
The DB2 Create Sequence tool contains the following options:
Sequence Name
Starts With
Increment By
Maximum Value
Minimum Value
Cache
Cycle
Order
The following is an example of the SQL generated from the DB2 Create Sequence Tool.
CREATE SEQUENCE TESTUSER.TEST_SEQUENCE
START WITH 1
INCREMENT BY 1
NO MINVALUE
MAXVALUE 1000
CYCLE
NO CACHE
ORDER
