Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

DROP SEQUENCE

Delete the sequence.

Synopsis

DROP SEQUENCE [IF EXISTS] name [, ...] [CASCADE | RESTRICT]

Description

DROP SEQUENCE deletes the sequence generator table. You must have the deleted sequence (or become a superuser).

Parameters

IF EXISTS

  • If the sequence does not exist, please do not report an error. In this case, a notification will be issued.

name

  • The name of the sequence to be deleted (can be specified by the schema).

CASCADE

  • Automatically delete sequence-dependent objects.

RESTRICT

  • If any object depends on the sequence, the deleted sequence is refused. This is the default value.

Example

Delete the sequence myserial:

DROP SEQUENCE myserial;

Compatibility

DROP SEQUENCE is fully compliant with the SQL standard, but this standard only allows one sequence to be deleted per command. Additionally, the IF EXISTS option is a YMatrix database extension.

See also

ALTER SEQUENCE , CREATE SEQUENCE

← Previous
DROP_SEGMENT_SET
Next →
DROP_SERVER