DROP SEQUENCE

Description

Drops 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 drop the sequence. By default, system administrators have the permission to drop the sequence.

Syntax

DROP SEQUENCE [ IF EXISTS ] { [schema.] sequence_name } [ , ... ] [ CASCADE | RESTRICT ];

Parameters

• IF EXISTS

  Reports a notice instead of an error if the specified sequence does not exist.

• sequence_name

  Specifies the name of the sequence to be dropped.

• CASCADE

  Automatically drops the objects that depend on the sequence.

• RESTRICT

  Refuses to drop the sequence if any objects depend on it. This is the default action.

Examples

1
2
3
4
5

-- Create an ascending sequence named serial, starting from 101.
openGauss=# CREATE SEQUENCE serial START 101;

-- Drop a sequence.
openGauss=# DROP SEQUENCE serial;

Helpful Links

ALTER SEQUENCE and DROP SEQUENCE