DROP SEQUENCE
Function
DROP SEQUENCE deletes a sequence from the current database.
Precautions
- Only the owner of a sequence, the owner of the schema to which the sequence belongs, or a user granted the DROP permission on a sequence or a user granted the DROP ANY SEQUENCE permission can delete a sequence. The system administrator has this permission by default.
- If the LARGE identifier is used when a sequence is created, the LARGE identifier must be used when the sequence is dropped.
Syntax
DROP [ LARGE ] SEQUENCE [ IF EXISTS ] {[schema.]sequence_name} [ , ... ] [ CASCADE | RESTRICT ];
Parameter Description
-
IF EXISTS
Reports a notice instead of an error if the specified sequence does not exist.
-
name
Specifies the name of the sequence to be deleted.
-
CASCADE
Automatically deletes the objects that depend on the sequence.
-
RESTRICT
Refuses to delete the sequence if any objects depend on it. This is the default action.
Examples
-- Create an ascending sequence named serial, starting from 101.
openGauss=# CREATE SEQUENCE serial START 101;
-- Delete a sequence.
openGauss=# DROP SEQUENCE serial;