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.
Must have DBA authority or be the owner of the sequence and have RESOURCE authority.
Sequences comprise SQL/2008 optional language feature T176.
The following example drops a sequence named Test:
DROP SEQUENCE Test;