Removes the specified named sequence number generator.
DROP SEQUENCE [ IF EXISTS ] [[database.]schema.]sequence[,…]
Specifies not to report an error if the sequences to drop do not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
Specifies a schema, by default
If you specify a database, it must be the current database.
Name of the sequence to drop.
Non-superusers: sequence or schema owner
- 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 SEQUENCEdoes not support the
CASCADEkeyword. 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
=> DROP SEQUENCE sequential;