DROP SEQUENCE

Function

DROP SEQUENCE deletes a sequence from the current database.

Precautions

• Only the owner of a sequence, the owner of the schema of the sequence, or users granted with the DROP permission on the sequence can delete the sequence. By default, the system administrator has the permission to delete the sequence.
• 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;

Helpful Links

ALTER SEQUENCE and DROP SEQUENCE