DROP SEQUENCE statement

Drops a sequence. This statement applies to SAP Sybase IQ catalog store tables only.

Syntax

DROP SEQUENCE [ owner.] sequence-name

Remarks

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.

Privileges

You must be the owner of the sequence, or have the DROP ANY SEQUENCE or DROP ANY OBJECT system privilege.

Side effects

None

Standards and compatibility

SQL/2008 – Sequences comprise SQL/2008 optional language feature T176.

Example

The following example creates and then drops a sequence named Test:

CREATE SEQUENCE Test
START WITH 4
INCREMENT BY 2
NO MAXVALUE
NO CYCLE
CACHE 15;
DROP SEQUENCE Test;