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.
None
SQL/2008 Sequences comprise SQL/2008 optional language feature T176.
The following example drops a sequence named Test:
DROP SEQUENCE Test;