GNU/Linux |
CentOS 5.4 |
|
![]() |
drop_sequence(7) |
![]() |
DROP SEQUENCE − remove a sequence
DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]
DROP SEQUENCE removes sequence number generators.
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.
To remove the sequence serial:
DROP SEQUENCE serial;
DROP SEQUENCE conforms to the SQL standard, except that the standard only allows one sequence to be dropped per command.
CREATE SEQUENCE [create_sequence(7)]
![]() |
drop_sequence(7) | ![]() |