CREATE SEQUENCE <sequence-name> ------------------+ +--------------------<----------------------------+ +---+---------------->-------------------------+--+ +---> STORED NAME IS ----> <stored-name> --+ | +--------------------<----------------------------+ +-+------------------>-------------------------+--> +-+-+---> sequence-attributes --------+-+----+ | +---> START WITH <numeric-value> -+ | +------------------<------------------+ sequence-attributes = --+--> INCREMENT BY <numeric-value> ---------+-> +--> sequence-range -----------------------+ +--> CYCLE --------------------------------+ +--> NOCYCLE ------------------------------+ +--> CACHE <numeric-value> ----------------+ +--> NOCACHE ------------------------------+ +--> ORDER --------------------------------+ +--> NOORDER ------------------------------+ +--> RANDOMIZE ----------------------------+ +--> NORANDOMIZE --------------------------+ +--> RESTART WITH -------------------------+ +--> WAIT ---------------------------------+ +--> NOWAIT -------------------------------+ +--> DEFAULT WAIT -------------------------+ +--> COMMENT -+-------+--+-> '<string>' -+-+ +-> IS -+ +------ / <-----+ sequence-range = -+-> MINVALUE -+-+--> <numeric-value> -+--+--> +-> MAXVALUE -+ +--> TINYINT ----+ | | +--> SMALLINT ---+ | | +--> INTEGER ----+ | | +--> BIGINT -----+ | +-> NOMINVALUE --------------------------+ +-> NOMAXVALUE --------------------------+