DROP SEQUENCENameDROP SEQUENCE -- remove a sequence SynopsisDROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ] Description DROP SEQUENCE removes sequence number generators.
Parameters- name
The name (optionally schema-qualified) of a sequence.
- CASCADE
Automatically drop objects that depend on the sequence.
- RESTRICT
Refuse to drop the sequence if any objects depend on it. This
is the default.
Examples To remove the sequence serial:
DROP SEQUENCE serial;
Compatibility DROP SEQUENCE conforms with SQL:2003.
|