Sequence creation

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

The following syntax diagram fragment shows sequence creation.


>>- -seq--+-sequence-+-----------------------------------------><
          '-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 IBM® Informix® Guide to SQL: Syntax.