YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

DROP SEQUENCE

Delete the sequence.

Summary

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

describe

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