CREATE SEQUENCE

Creates a new sequence object in the database.

Syntax

CREATE SEQUENCE [ IF NOT EXISTS ] sequence-name
[ INCREMENT BY integer 
| START WITH integer
| NOMAXVALUE
| MAXVALUE integer
| NOMINVALUE
| MINVALUE integer
| CYCLE
| NOCYCLE
| CACHE integer
| NOCACHE
| ORDER
| NOORDER
]