Lu, Huayi e6fa411af0 DWS DEV 830.201 version

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:24:04 +00:00

4.8 KiB

Raw Permalink Blame History

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

1
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

Delete the sequence serial:

1
DROP SEQUENCE serial;

Helpful Links

CREATE SEQUENCE ALTER SEQUENCE

Parent topic: DDL Syntax

4.8 KiB Raw Permalink Blame History