DROP SEQUENCE

DROP SEQUENCE deletes a sequence from the current database.

Only a sequence owner or a system administrator can delete a sequence.

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

**Table 1** DROP SEQUENCE parameters
Parameter	Description	Value Range
IF EXISTS	Sends a notice instead of an error if the specified sequence does not exist.	-
name	Specifies the name of the sequence to be deleted.	Specifies an existing sequence name.
CASCADE \| RESTRICT	Specifies how to process related data in the dependent object when a delete operation is performed.	CASCADE: Automatically deletes objects that depend on the sequence to be deleted. RESTRICT: Refuses to delete the sequence if any objects depend on it. This is the default action.

Delete sequence serial.

 DROP SEQUENCE serial;
 

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.