602SQL Documentation Index  


statement_CREATE_SEQUENCE :== CREATE [ IF NOT EXISTS ] sequence_description

The CREATE SEQUENCE statement creates a new sequence according to the description.

The maximum length of a sequence name is 31 characters. Each sequence must have a unique name in the schema context. If the specified sequence name already exists the error sqlstate 40004 (KEY_DUPLICITY) occurs.

You may not use the RESTART WITH clause in the sequence description when calling the CREATE SEQUENCE statement.

Execution of this statement always commits an open transaction.

You can also create a sequence from the Control Panel of the 602SQL Client.