Drops a specified sequence.
1 – Environment
You can use the DROP SEQUENCE statement:
o In interactive SQL
o Embedded in host language programs
o As part of a procedure in an SQL module or other compound
statement
o In dynamic SQL as a statement to be dynamically executed
2 – Format
(B)0[m[1;4mDROP[m[1m [1;4mSEQUENCE[m[1m <sequence-name> qqwqwqqqqqqqqqqqqqqqwqwqq> [m
[1m [m [1mx tqq> [1;4mCASCADE[m[1m [m [1mqqu x [m
[1mx[m [1mtqq> [1;4mRESTRICT[m [1mqqu x[m
[1mx[m [1mmqq>[m [1;4mIF[m[1m [1;4mEXISTS[m[1m qj[m [1mx[m
[1mmqqqqqqqqqqq<qqqqqqqj[m
3 – Arguments
3.1 – CASCADE
The CASCADE clause specifies that you want SQL to invalidate
all objects that refer to the sequence and then delete the
sequence definition. If you delete a sequence referenced by a
stored routine or trigger with a routine or language-semantic
dependency, SQL also marks the affected stored routine or trigger
as invalid.
3.2 – IF_EXISTS
Prevents SQL command language from displaying error messages if
the referenced object does not exist in the database.
3.3 – RESTRICT
The RESTRICT clause prevents the removal of a sequence definition
(the DROP SEQUENCE statement fails) when the sequence is
referenced by any other object within the Oracle Rdb database.
The RESTRICT clause is the default.
3.4 – sequence-name
An existing sequence name in the database. To specify lowercase
characters or characters not in the SQL repertoire, enclose the
sequence name in single quotation marks (').
4 – Examples
Example 1: Dropping a Sequence
SQL> SHOW SEQUENCE;
Sequences in database with filename mf_personnel.rdb
EMPID
SQL> DROP SEQUENCE EMPID;
SQL> SHOW SEQUENCE;
Sequences in database with filename mf_personnel.rdb
No Sequences Found
SQL>