DROP SEQUENCE

Removes the specified named sequence number generator.

Syntax

DROP SEQUENCE [schema.]sequence‑name[,...]

schema	Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject
sequence‑name	Specifies the sequence to drop.

One of the following:

For sequences specified in a table's default expression, the default expression fails the next time you try to load data. Vertica does not check for these instances.
DROP SEQUENCE does not support the CASCADE keyword. Sequences used in a default expression of a column cannot be dropped until all references to the sequence are removed from the default expression.

The following command drops the sequence named sequential.

=> DROP SEQUENCE sequential;