Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> DROP SEQUENCE
View PDF

DROP SEQUENCE

Function

DROP SEQUENCE deletes a sequence from the current database.

Precautions

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

Syntax

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

Parameter Description

  • IF EXISTS

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

  • name

    Specifies the name of the sequence.

  • 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.

Examples

1
2
3
4
5
 
-- Create a sequence named serial that starts from 101 and increases in ascending order:
CREATE SEQUENCE serial START 101;

-- Delete the sequence:
DROP SEQUENCE serial;

Helpful Links

CREATE SEQUENCE ALTER SEQUENCE

Parent topic: DDL Syntax