Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Drops a sequence.
DROP SEQUENCE [ owner.] sequence-name
If the named sequence cannot be located, an error message is returned. When you drop a sequence, all synonyms for the name
of the sequence are dropped automatically by the database server.
You must be the owner of the sequence, or have the DROP ANY SEQUENCE or DROP ANY OBJECT system privilege.
Sequences comprise SQL/2008 optional language feature T176.
The following example creates and then drops a sequence named Test:
CREATE SEQUENCE Test
START WITH 4
INCREMENT BY 2
DROP SEQUENCE Test;