Sequence creation

The dbschema -seq sequence command generates information about sequence creation.

The following syntax diagram fragment shows sequence creation.


1  -seq
1 sequence
1 all
Element Purpose Key Considerations
-seq sequence Displays the CREATE SEQUENCE statement defining sequence None.
-seq all Displays all CREATE SEQUENCE statements for the database None.
Running dbschema with option -seq sequitur might produce this output:
CREATE SEQUENCE sequitur INCREMENT 10 START 100 NOCACHE CYCLE

For more information about the CREATE SEQUENCE statement, see the HCL OneDB™ Guide to SQL: Syntax.