|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
DROP SEQUENCE to UPDATE, 2 of 27
SEQUENCE statement to remove a sequence from the database.
You can also use this statement to restart a sequence by dropping and then re-creating it. For example, if you have a sequence with a current value of 150 and you would like to restart the sequence with a value of 27, you can drop the sequence and then re-create it with the same name and a
WITH value of 27.
The sequence must be in your own schema or you must have the
SEQUENCE system privilege.
Specify the schema containing the sequence. If you omit
schema, Oracle assumes the sequence is in your own schema.
Specify the name of the sequence to be dropped.
The following statement drops the sequence ESEQ owned by the user
elly. To issue this statement, you must either be connected as user
elly or have
SEQUENCE system privilege: