DROP SEQUENCE
Removes the specified named sequence number generator.
Syntax
DROP SEQUENCE [schema.]sequence‑name[,...]
Parameters
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. |
Privileges
One of the following:
- Superuser
- Sequence or schema owner
Restrictions
- 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 theCASCADE
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.
Example
The following command drops the sequence named sequential
.
=> DROP SEQUENCE sequential;