Sequence creation
The dbschema -seq sequence command generates information about sequence creation.
The following syntax diagram fragment shows sequence creation.
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.