Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
DROP SEQUENCE to ROLLBACK, 2 of 20
Use the DROP
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 START
WITH
value of 27.
See Also:
|
The sequence must be in your own schema or you must have the DROP
ANY
SEQUENCE
system privilege.
drop_sequence::=
drop_sequence
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.
DROP
SEQUENCE
Example
The following statement drops the sequence orders_seq
owned by the user oe
(created in "CREATE SEQUENCE Example"). To issue this statement, you must either be connected as user oe
or have DROP
ANY
SEQUENCE
system privilege:
DROP SEQUENCE oe.orders_seq;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|