Example of CREATE OR ALTER SEQUENCE
Create a new or modify an existing sequence
EMP_NO_GEN
CREATE OR ALTER SEQUENCE EMP_NO_GEN
START WITH 10
INCREMENT BY 1
CREATE OR ALTER SEQUENCE
EMP_NO_GEN
CREATE OR ALTER SEQUENCE EMP_NO_GEN
START WITH 10
INCREMENT BY 1
DROP SEQUENCE
Drops a SEQUENCE
(GENERATOR
)
DSQL, ESQL
DROP {SEQUENCE | GENERATOR} seq_name
Parameter | Description |
---|---|
seq_name |
Sequence (generator) name.The maximum length is 63 characters |
The statements DROP SEQUENCE
and DROP GENERATOR
statements are equivalent: both drop (delete) an existing sequence (generator).Either is valid but DROP SEQUENCE
, being defined in the SQL standard, is recommended.
The statements will fail if the sequence (generator) has dependencies.